Comments by Abhijeet pratap singh (Top 20 by date)

The best way to handle this is to keep the connection string in a config file and provide a version for each installation with "points" at the appropriate server instance. That is what I do!



pls explain more these lines

i want both but currently i want for single user
thanks for reply u have great knowledge
so pls tell me for both but first for single user software which can run on each computer
i am developing a stock management software it almost done but now i want a software which installa n run on each computer

then which database or technique i have to use that the software can run on each computer like other softwares iam developing software in c#.net

then which database or technique i have to use that the software can run on each computer like other softwares iam developing software in c#.net

can you tell me how and what give in connection string for sql server
that the software run on each computer on creating msi file

nops pls read first my question
thanx fr revert

but his is the solution when create table
bur i have already created the table
and i am using SqlServer 2008

in this grid i have all rows
now i want sorted according to date
between two datetimepicker

selectQueryString = "SELECT * FROM misc_info WHERE misc_date BETWEEN @'" + dateTimePicker1.Value + "' AND @'"+dateTimePicker2.Value+"'";
con.Open();
try
{
sqlDataAdapter = new SqlDataAdapter(selectQueryString, con);
sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
bindingSource = new BindingSource();
bindingSource.DataSource = dataTable;
dataGridView1.DataSource = bindingSource;

}
catch (Exception rr)
{ }

in this grid i have all rows
now i want sorted according to date
between two datetimepicker

selectQueryString = "SELECT * FROM misc_info WHERE misc_date BETWEEN @'" + dateTimePicker1.Value + "' AND @'"+dateTimePicker2.Value+"'";
con.Open();
try
{
sqlDataAdapter = new SqlDataAdapter(selectQueryString, con);
sqlCommandBuilder = new SqlCommandBuilder(sqlDataAdapter);
dataTable = new DataTable();
sqlDataAdapter.Fill(dataTable);
bindingSource = new BindingSource();
bindingSource.DataSource = dataTable;
dataGridView1.DataSource = bindingSource;

}
catch (Exception rr)
{ }

not getting it
datetimepicker return value in dd/mm/yyyy hh:mm:ss pm
and it will not sorting
i used @datetimepicker1.value instead of @date1

because i have enter some item which is in collection string
and now on another winform i have to accept only the items which is in collection string only
thats user cant create mistake to enter the items name

thanx for reply

by this user cant enter any string except the collection string
and it will help to prevent the wrong entries

no i have already applied autocomplete
the next i want is if AutoCompleteStringCollection have three values which are
1- abhi
2- jeet
3- pratap

then when i press any charecter except (a , j , p) it will not accept because collection string have only (a , j ,p) as starting char.

and after this if i press 'a' then it only accepts b after a because abhi have b after a


thanx for revert