|
you can do one thing , insted of read the Table name in List box use a combobox, when selet one table from combobox all column name will come with in a list box and you can move to another list box. Which make simple and easy.
Or you can use collection for that !!!!!!
Good luck !!!
|
|
|
|
|
Hi friends
I am facing a problem while accessing database sqlserver 2005 from command prompt.
Here i am giving my code. I don't have any compilation errors,
But runtime errors as follows....
Unhandled Exception: System.Data.SqlClient.SqlException: An error has occurred w
hile establishing a connection to the server. When connecting to SQL Server 200
5, this failure may be caused by the fact that under the default settings SQL Se
rver does not allow remote connections. (provider: Named Pipes Provider, error:
40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception
my code is :
using System;
using System.Data;
using System.Data.SqlClient;
/// <summary>
/// Demonstrates how to work with SqlConnection objects
/// </summary>
class SqlConnectionDemo
{
static void Main()
{
// 1. Instantiate the connection
string strConnection = "server=localhost; Trusted_Connection=yes; timeout=120";
SqlConnection Conn = new SqlConnection(strConnection);
SqlDataReader rdr = null;
try
{
// 2. Open the connection
if (Conn.State == ConnectionState.Closed)
{
Conn.Open();
}
// 3. Pass the connection to a command object
SqlCommand cmd = new SqlCommand("select * from Customers", Conn);
// 4. Use the connection
// get query results
rdr = cmd.ExecuteReader();
// print the CustomerID of each record
while (rdr.Read())
{
Console.WriteLine(rdr[0]);
}
}
finally
{
// close the reader
if (rdr != null)
{
rdr.Close();
}
// 5. Close the connection
if (Conn != null)
{
Conn.Close();
}
}
}
}
Note: I am executing my program at cmd prompt.
Help please...........
|
|
|
|
|
mohanallam wrote: // 1. Instantiate the connection
string strConnection = "server=localhost; Trusted_Connection=yes; timeout=120";
SqlConnection Conn = new SqlConnection(strConnection);
In this line are you specifyinng DataSource or InitialCatalog ? I think you also need to specify the data base you want to connect to.
I believe you are accessing SQL Server on the same machine as you have your code in, which is also visible from the Server=localhost line of code.
If your DB server lies on some remote machine you gotta change some settings from SQL Server Surface Area Configuration regarding local and remote connections.as under default settings, remote connnections are not allowed by SQL Server and you may also need to turn off your firewall to be able to access remote server.
Also, you can have various versions of connection strings for connecting to SQL server.
Just try specifying the initial catalog and/or datasource parameters in the connection string and see if it works. if it doesnt let me know.
|
|
|
|
|
ThankQ gladiatron
I am very happy with u r replay . i got something form u r replay.But i have some other problems regarding this.
So kindly send me u r Mail ID;
My mail Id is :allam_mhn@yahoo.co.in or mohanallam@gmail.com
thankQ
|
|
|
|
|
Hi,
I am not very familiar with Installers hence need help.
I would like to allow user to choose from various options while installing the windows application. When he runs the application, it should read what user had selected at the time of installation and show/hide items accordingly.
Is there any way to do this? Or do I need to write this in some file? .config file may be. But I would like to avoid writing to a file.
Thanks a lot.
-AD
Every bit counts
|
|
|
|
|
you can store the user option in registry or in a config file, if you were not planning to write file, registry may be a choice.
|
|
|
|
|
I believe, a strong solution is indeed what you are trying to avoid....u get it.."FILES"....
You can write the installation settings onto a text file and keep it hidden somewhere on the user machine, thts one of the best ways, really.
Alternatively, you can use windows registry to store the installation settings which is suppposedly the best way and the usual way other applications store settings during installation.
I havent tried the latter approach though and you may have to refer MSDN for this, u can get the complete code for your kinda requirements on MSDN.
Files have been my favorite way out for quite some time now.
|
|
|
|
|
hi.. the bottom code work very well.. but i have a few questions here..
for that code below..
1) i did not declare any connectionstring
2) i did not call any sqlcommand query e.g. "select name from ..."
is the way i do below good or bad? will it make things slow? because i did not specify the query "select name from.." .. , so the system will take time to take out all the data ?? instead of specify to my query?
there are so many ways to do that .. e.g databinding to textbox.. so compared to this below?
void call_textbox()<br />
{<br />
DataTable store = new DataTable();<br />
father.Fill(son.table);<br />
store = son.table;<br />
<br />
if (listBox1.SelectedIndex != -1)<br />
{<br />
foreach (DataRow row in store.Rows)<br />
{ <br />
if (row[0].ToString() == store.Rows[listBox1.SelectedIndex].ItemArray[0].ToString())<br />
{<br />
name.Text = row[1].ToString();<br />
address.Text = row[2].ToString();<br />
phone.Text = row[3].ToString();<br />
}<br />
<br />
<br />
}<br />
}<br />
<br />
}
|
|
|
|
|
are you want to select the record from the DataTable that the row index = listBox1.SelectedIndex????
if so, why not
DataRow row = store.Rows[listBox1.SelectedIndex];
name.Text = row[1].ToString();
...
And there has a RowFilter properties in DataView(or DataTable.DefaultView), you can use it for filter any record you want...
check it out in MSDN:
http://msdn2.microsoft.com/en-us/library/system.data.dataview.rowfilter.aspx[^]
|
|
|
|
|
thanks for reply.. anyway..my question is not on the listbox coding..
i have a few questions here..
for that code..
1) i did not declare any connectionstring
2) i did not call any sqlcommand query e.g. "select name from ..."
because if we specify the sqlcommand, will it save time to look for the data that we want instead of doing that in datatable like what i did above..??
why i did not declare the conntectionstring also can work? i did not declare the Using System.sqlclient..
which way is better ?
|
|
|
|
|
1) the connectionString has been stored in Properties.settings.
2) if you were drag and drop the datatable in to your program, SELECT, UPDATE, DELETE, INESRT Command will generate to you automatically...
Depends on the usage in your program, if you will handle all sql command, it should be "faster".
but if the record is not larger than 100,000. I don't think there has too much different. But development time
|
|
|
|
|
thanks.. so which mean the way i did is faster in development time ??
|
|
|
|
|
i has also posted before to other forum.. what they said was the way i did will be slowing down eveyrthing..
|
|
|
|
|
|
Sorry for late reply.
If you want to have a faster development time, you have to use the predefine or auto-gen code for your development, it will slow down the work, but it save in coding.
But if you have time to design a better software structure, it will take time but faster in performance.
It's depends on your choice.
|
|
|
|
|
hi i use the below code to update..
DataTable store = new DataTable();
store = son.Table1;
father.Update(name.Text, ......)
but visual prompt me soemthing weird when i put " , " after name.text
in my Table1 only have "id, name, address" .
why after "," it prompt me update(string name, string address, int Original_ID, string Origianl_name, string Original_address, int ID)
i cant update if i din all those things.. something is wrong with my database.. ? i checked.. it shown only 3 fields
|
|
|
|
|
if your "father" (is it a good variable name?? ) mean SqlDataAdapter, why don't you update the whole dataset or datatable???
and SqlDataAdapter.Update will be execute the UpdateCommand that predefine in the SqlDataAdapter.UpdateCommand, did you set the command correctly??
|
|
|
|
|
do u mean i need to add query for update for my dataset ? i did not set the command.. cos when i put " father. " after the . it shown me the update..
the update already there// ? should i add that query ??
|
|
|
|
|
i try to add the update query at the tableadapter query configuration wizards. it show like this
<br />
UPDATE [Table1] SET [name] = @name, [address] = @address, [phone] = @phone WHERE (([id] = @Original_id) AND ((@IsNull_name = 1 AND [name] IS NULL) OR ([name] = @Original_name)) AND ((@IsNull_address = 1 AND [address] IS NULL) OR ([address] = @Original_address)) AND ((@IsNull_phone = 1 AND [phone] IS NULL) OR ([phone] = @Original_phone)));<br />
SELECT id, name, address, phone FROM Table1 WHERE (id = @id)
why not like this
UPDATE [Table1]<br />
SET name = @name, address= @address, phone = @phone<br />
WHERE (Id = @Original_Id); <br />
SELECT Id, name,address,phone FROM [User] WHERE (Id = @Id)
|
|
|
|
|
it's prevent if there has 2 users editing the record, if A has submit the update command, then B SHOULD NOT be update and the program should handle the roll back.
a easy example, if 2 people want to buy a movie ticket online, and they were select for the same seat, if A has submit the data, could B update the DB also??
if the update command is ready, just provide the dataset/datatable to the adapter is fine
in your case, it should be:
father.Update(son);
|
|
|
|
|
|
Hi rameshgoudd,
You already posted around 34 posts in our forum so that you are NOT new anymore. You should check which forum you are in before posting the message. Now, you posted the database-related question in C# forum.
Another thing is that you should search in Google first. Look at this search T-SQL SELECT[^]. You will get what you want in a few second. So, you don't need to wait our replies too.
|
|
|
|
|
Can anyone recommend an image processing library, readily usable from C#? preferably free (even if "crippled"), as I am just toying around at the moment. Specifically, I am looking for:
* resizing + cropping
* color adjustment (brightness, contrast, color space optimizations)
* text overlay
* lossless rotate for jpegs
|
|
|
|
|
I used to use the Paint.NET to edit the images. But I'm not sure whether they make it as a library or combine everything into UI. Anyway, you can take a look their codes and customize the way you want.
|
|
|
|
|
I have a pop up window in my app to search a xml file, when the user clicks on the red 'X' to close the window I just want to turn the window visible = false, so the next time they go to open the window it just sets visible = true (allowing me to access all the functions in the Find class even when the find window is closed). To the problem i am having is that when I do:
void Find_FormClosing(object sender, FormClosingEventArgs e)
{
....
}
it still disposes the form... what event should I be dealing with? How do I do this?
Thanks
|
|
|
|