|
Hi
Use the following snippet for retrieving table names....
OleDbConnection connection = new OleDbConnection(<connetcionstring>);
connection.Open();
object[] restrictions;
restrictions = new object[] {null , null , null , "TABLE"};
DataTable table;
table = connection.GetOleDbSchemaTable(OleDbSchemaGuid.Columns,restrictions);
connection.Close();
then,
this.cmbTables.DataSource = table;
this.cmbTables.DisplayMember = "TABLE";
I hope it works for you.
|
|
|
|
|
First of all get rid of the new table names stuff and check if you can read data from the tables by using your OleDb code.
Fill some sample data in Access and use
..
.
.
.
.
string sqlSelectStatement = "SELECT * FROM <tablename>";
OleDbDataAdapter adapter = new OleDbDataAdapter =(sqlSelectStatement,connection);
connection.Open();
DataTable table = new DataTable();
try
{
adapter.Fill(table);
}
connection.Close();
Now look in table and tell the result.
|
|
|
|
|
I get the containment of the Table.
So that works as it should
But how to go on now?
The underdog
|
|
|
|
|
If your OleDb code work then as you did last time,
comboBox1.DataSource = table;
combobox1.DisplayMember = columnNameYouWantToListInTheTable as string;
should work.
I dont know what the column name is.
Try some possibilities.
Sorry for incomplete help.
|
|
|
|
|
Hi...
I have some text i want to add to a string!
The text would look like this:
<?xml version="1.0" encoding="utf-8"?>
But i have no idea how to do it... i would do like this:
string a = "<?xml version="1.0" encoding="utf-8"?>";
But that does not work!
Can anyone tell me how to add this to a string..?
Thanks!
QzRz
|
|
|
|
|
Hi,
Put '@' character before the string to inhibate the effect of inner quotes.
string a = @"";
To add a string to another use
String.Concat(string str1 , string str2, .... );
These will work if I got your problem right.
|
|
|
|
|
well... it does not work... 
i did this:
string a = @"<?xml version="1.0" encoding="utf-8"?>";
I am using microsoft visual studio .net 2002!
And it puts a red line under '1.0" encoding=@"utf-8"?>"' and i cannot debug!
Do you have another idea of how to solve this...?
Thanks...!
QzRz
|
|
|
|
|
Escape the quotation marks.
string a = "<?xml version=\"1.0\" encoding=\"utf-8\">";
www.troschuetz.de
|
|
|
|
|
Escape the quotation marks.
What does that mean?
do not understand:
string a = "";
QzRz
|
|
|
|
|
Sorry, i forgot to check the "Do not treat <'s as HTML tags" option.
Here it is again.
string a = "<?xml version="1.0" encoding="utf-8"?>";
|
|
|
|
|
It still gives me same problem!
Nomatter if i write:
string a = @"<?xml version="1.0" encoding="utf-8"?>";
or
string a = "<?xml version="1.0" encoding="utf-8"?>";
it still wont work...!
QzRz
|
|
|
|
|
It's definitely not my day: this time i forgot to escape the quotation marks.
Let's give it one more try 
string a = "<?xml version=\"1.0\" encoding=\"utf-8\"?>";
|
|
|
|
|
that works... thanks...!
QzRz
|
|
|
|
|
Do not use quotation marks '"' for 1.0 and utf-8, you can use single quotes.
If this will be an XML file I have checked single quote before and it has worked.
|
|
|
|
|
How is it possible to pass the property name as string and get the value of the property?
Any link is also ok.
|
|
|
|
|
|
how would i add a string were the current index is(caret)??
IM PROUD TO BE A GMAIL;
|
|
|
|
|
The string class has an Insert method that takes an int specifying the index at which to insert the new string and the string to insert. TextBox.SelectionStart will give you index where the caret is currently located if there is no text selected, or the beginning of the selection if there is. You'll probably want to replace the selected text if there is any. You'd use String.Remove for that.
Charlie
if(!curlies){ return; }
|
|
|
|
|
thanks
IM PROUD TO BE A GMAIL;
|
|
|
|
|
can you help me since im using .net v2.0 and this might be a bug but...
if (textBox1.SelectionLength != 0)<br />
{<br />
textBox1.Text.Remove(textBox1.SelectionStart, textBox1.SelectionLength);<br />
}<br />
textBox1.Text.Insert(textBox1.SelectionStart, tempstring);
(it doesn't work for me)
IM PROUD TO BE A GMAIL;
|
|
|
|
|
It's not a bug. Strings in .NET are immutable, which means they cannot be changed once they are initialized. Calling Insert or Remove on a string does not change the object on which the method was called; It returns a new string with the new value.
string s1 = "This is a string.";
string s2 = s1.Insert(10, "new ");
Console.WriteLine(s1);
Console.WriteLine(s2);
If you do want to change the string that s1 references, you'd assign the return value from the method you're calling to it.
string s1 = "This is a string.";
s1 = s1.Insert(10, "new ");
Console.WriteLine(s1);
Charlie
if(!curlies){ return; }
|
|
|
|
|
crap, thanks again, i still getting used to the .net framework  
IM PROUD TO BE A GMAIL;
|
|
|
|
|
I am trying to solve these 2 exercises. I don't know where to start.
Could someone please help me with the start and sample code?
Exercise 18-1: Write a module that will handle page formatting. It should contain the following functions: open_file(char *name) Open print file. define_header(char *heading) Define heading text. print_line(char *line) Send line to file. page(void) Start new page. close_file(void) Close printer file. ----------------
Exercise 18-2: Write a module called search_open that is given an array of filenames, searches until it finds one file that exists, and then opens the file. ---------------- DO NOT FORGET TO WRITE RESPECTIVE MAIN MODULES
|
|
|
|
|
You should attempt your homework first. Your tutor should have given you all the materials you need to complete the exercise already. If you get stuck on your attempt, please post with a specific question about a specific problem you are having. Do not just post your homework questions and expect someone to answer; you will not learn anything that way.
Finally, when you do have a specific problem, please post it to the correct forum. This forum is for questions on C#, not C.
Do you want to know more?
|
|
|
|
|
Hi!
I am writing a client/server application that uses sockets as the network interface. When I, in the client code, try to connect to the server by using BeginConnect with the wrong IP-address, my form freezes immediately and remains that way until an exception is thrown. Is there any way to prevent this from happening? Can I control how how long before the exception is thrown? I was using the construct below to solve the timeout issue, but that does not restore the state of my form. I assume the BeginConnect must be interrupted in some way, but I don't know if that can be done?
IAsyncResult connResult = this.remoteHost.BeginConnect(
remoteEndPoint, null, null );
// wait until the BeginConnect finishes
if ( connResult.AsyncWaitHandle.WaitOne(timeOut, false ) )
{
}
else
{
// WaitOne timed out
}
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
