hi
i got this error:
CLR Error: 80004005
when i try to run my C# program on Windows XP.
when i try to install FrameWork 2.0 - i got this error:
there is a problem with this windows installer packege.
what can be the problem ?
thank's in advance
hi
why in Windows 7 i see the Data & Time in DataTimePicker inverse
and in Windows XP it fine ? (the region and language are same)
ex.
Win7: 2010/12/31 - 51:09
XP : 31/12/2010 - 09:51
thank's in advance
I have Text file that contains data separated with a comma ,.
How do I load this to access in the fastest way?
The Text file contains 200,000 rows.
I work with C#.
hi
i have buield my project on VS2008 under FrameWork 3.5
now i need to move to FrameWork 2.0
when i done this, i got this error:
Error 1 The type or namespace name 'TypedTableBase' does not exist in the namespace 'System.Data' (are you missing an assembly reference?) C:\Documents and Settings\xxx\Desktop\demo2005\demo\MyDB.Designer.cs 391 68 demo
in this line:
public partial class DO1TblDataTable : global::System.Data.TypedTableBase<DO1TblRow> {
i think that it something with the crystal-report
thank's in advance
hi
i have this code:
ConnectString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + ExcelFile + ";Extended Properties=\"Excel 12.0 Xml;HDR=No\"";
SheetName = SheetName.Substring(0, SheetName.Length - 5);
OleDbConnection Connection = new OleDbConnection();
Connection.ConnectionString = ConnectString;
try {Connection.Open();}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
OleDbDataAdapter Command = new OleDbDataAdapter("SELECT * FROM [" + SheetName + "$]", Connection);
DataSet ExcelData = new DataSet();
try {Command.Fill(ExcelData);}
catch (Exception EX)
{
MessageBox.Show(EX.Message);
}
finally
{
if (Connection.State != ConnectionState.Closed)
Connection.Close();
}
but not all the data in column 1 insert - i get empty data why ? what can be wrong ?
thank's in advance
hi
i have table that contain date and time field.
id|date|time
=========
1|01/01/2001|10:45
2|01/02/2002|11:45
3|01/03/2003|12:45
4|01/04/2004|12:55
i need to know the difference between the MAX(date) and the MIN(date)
and the MAX(time) and the MIN(time)
something like.... MAX(date)-MIN(date) ???.....
thank's in advance
hi
need signature sample on Windows-Mobile (paint)
how to draw on Windows-Mobile on screen - and save the Picture ?
can i get sample code (C#) ?
thank's in advance
I have 2 tables:
Table A: code | name
Table B: barcode | name
Table B has full barcode and name, Table A has only code.
I need to run update query that fill name in Table A.
I tried something like:
update A set name = (select top 1 Name from B where B.Code = mid(A.Barcode,1,8))
but it doesn't work.
I have this insert query:
try {
Cmd.CommandText = @"INSERT INTO BarcodTbl SELECT * FROM [Text;DATABASE=" + PathI + @"\].[Tmp.txt];";
Cmd.ExecuteNonQuery();
Cmd.Dispose();
} catch (Exception ex) {
MessageBox.Show(ex.Message);
}
I have two questions:
How can I run a progress-bar from the beginning to the end of the insert?
If there is an error, I got the error exception and the action will stop - the query stops and the BarcodTbl is empty. How I can see the error and allow the query to continue filling the table?
How do I force a user to type only two digits after the decimal point?
For example:
100 - good
100.1 - good
10.21 - good
10.123 - bad
21.1234 - bad
I need it at entry time - in C# and Windows CE.
hi
i have this table:
id|date
1 | 10/11/2009
2 | 13/11/2009
1 | 20/12/2009
3 | 21/12/2009
1 | 30/12/2009
if i stand on the last record (id=1) and i need to see the last date where
id=1 is appear -- will show me: 1 | 20/12/2009
what query will do it ?
thank's in advance
hi
i have sql-server 2008 database that in the main server.
i have 10 terminals that connect to this server and work against the database.
i need that every new inserting to database through any terminal - in the server this
line will inserting to text file (every line)
can i do it ?
thank's in advance
hi
how to send 2-3 param's to Winform C# program ?
for example: i'll send something like MyProg.exe 10 20 "abc"
and in my program i can receive those values
(i dont want to show MyProg.exe - it will work background)
thank's in advance
hi
i have 4000 records, and i need to pick randomize 500 records.
i need that 500 records will insert to GoodTable
and the rest 3500 records will insert to BadTable
how to do it using sql-server 2008 query ?
thank's in advance
hi
how to force user for typing only 2 digit after the dot ?
for example:
100 - good
100.1 - good
10.21 - good
10.123 - bad
21.1234 - bad
i need it in the type time - in C# and Windows CE
thank's in advance
hi
i have 2 tables
table items has 144602 records
table A has 27721 records
code in items = BAR8 in A
i want to show all records that equal
i try this: SELECT Items.Code, A.BAR8
FROM Items INNER JOIN A ON Items.Code = A.BAR8;
and i get 28048 records !!! i need to get 27721 , how to do it ?
thank's in advance
hi
i can't install sql-server 2008 on Windows Server 2003 standard edition SP1
i get this error: Minimum Operation System Version Failed
thank's in advance