|
Did you check by applying the break point aah? did you get the value or not? And what error it shows?
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
hi,
it is not giving any error,
to get the same values from the two arrays ..i wrote the logic like this,
first array first element checks with all the second array elemnts..if it find any matches ..it returns the matched value..like second element with all the elements of second array.
but to get the elemenet which is in first array and which is not second array..
i wrote like this,
first array element checks with the all the elements in the second array..if he does not found any matches it returns the unmatched values ....this is wrong na..becasue this first elemnt unmacthedvalues may be equal to the second element in the first array
how can i write the logic for this
|
|
|
|
|
Hi all,
I want to use 3 lists ,list1,list2 and list3...
list1 contains the list of tables.list2 contains the list of columns corresponding to the table in the list1.
user selects the columns by checking them and presses a button and the column is moved to list3.
I have an idea to do it.But the main problem,when the user finishes the selection ,I want to see which tables are selected and which columns corresponding to which tables are selested...
Regards,
chanzeb chaudhary
modified on Thursday, December 06, 2007 11:56:49 PM
|
|
|
|
|
Please make your subject for the post corectly.Dont make it as Help meeeee!!!! ie., not good here we all are here to help you.
SSK.
Anyone who says sunshine brings happiness has never danced in the rain.
|
|
|
|
|
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);
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
