|
sqldatasoruce1.selectcommand = "select * from emp";
if i want the particular result like someone emp name how to get it?
thanks.
modified on Friday, August 1, 2008 6:08 AM
|
|
|
|
|
where emp.name = "something"
or if you are comparing to string
where emp.name = '" + stringname + "'"
|
|
|
|
|
that is ok select * from emp where emp_id = 1
but now i want to print the value
how to get this value???
thanks.
|
|
|
|
|
SqlDataReader readerEmp = sqldatasoruce1.ExecuteReader();
while(readerEmp.Read())
{
int EmpID = (int)readerEmp["Emp_ID"];
//the "emp_id" is the column name in the sql database.
string EmpName = (string)readerEmp["Emp_Name"];
}
|
|
|
|
|
sorry no such thing SqlDataSource.ExecuteReader() ?????
|
|
|
|
|
ok, ur misunderstanding. Heres code from something i did a while back. just adapt it to your needs.
sqlConn.Open();
SqlCommand cmdShowCat = sqlConn.CreateCommand();
cmdShowCat.CommandText = "SELECT * From Type WHERE TypeName LIKE '[R]%'";
SqlDataReader readerShowCat = cmdShowCat.ExecuteReader();
while(readerShowCat.Read())
{
string TypeName = (string)readerShowCat["TypeName"];
catagoriesLabel.Text = catagoriesLabel.Text + " " + TypeName;
}
if (catagoriesLabel.Text == "") { catagoriesLabel.Text = "Sorry, there were no results."; }
sqlConn.Close();
|
|
|
|
|
SqlDataSource sds = new SqlDataSource();
sds.ConnectionString = ConfigurationManager.AppSettings[0];
sds.SelectCommand = "select datediff(day, date_, '7/26/2008') from date_tab ";
i want the result in my case the date difference from this query
thanks.
|
|
|
|
|
hello frndz,
I am very confused, which transaction level should i use ???
What i want to do is , I have to insert 1000 value in a database table n i used transaction handling concept for that purpose.
My Isolation level is "READ COMMITED" but if any other user try to insert record in same table then it will retun me TIME OUT exception.
i think it will lock whole table till i completed my transaction...
what can i do for it ???
can i lock that perticular rows which i inserted???
any other hint ??? that table should not get locked ???
I have Sqlserver 2000 and .NET 2.0
thanks in advance
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Use Stored procedure instead of single transactions..
it lockes the SQL from its process Begin...to....End.
Anand Desai
Developer
Atharva Infotech
|
|
|
|
|
iam using a iframe for my mailing application .the problem is if i write some text and press enter 3 times and in the hidden field value the inner html of the iframe is getting the space which press enter 3 time like nsbsp like this how to solve this problem
|
|
|
|
|
Hi
I am using tables to do the outline design for my webpage.
The problem is, is that there is small gaps between each tables which I want to remove so that all areas are tight to each other.
Is there a way to do this, like reduce padding on table or border?
thanks
|
|
|
|
|
For the <table> tag:
<table cellpadding="0" cellspacing="0">
Regards,
--Perspx
"The Blue Screen of Death, also known as The Blue Screen of Doom, the "Blue Screen of Fun", "Phatul Exception: The WRECKening" and "Windows Vista", is a multi award-winning game first developed in 1995 by Microsoft" - Uncyclopedia
|
|
|
|
|
|
how to connect the web cam to my application.and also how to capture the picture.after cpturing the pic it can be saved in image location .it just like preparing the id card.
|
|
|
|
|
I dont think you can do this in asp.net
|
|
|
|
|
put code to start exe in event holder
Anand Desai
Developer
Atharva Infotech
|
|
|
|
|
I have DataGrid and am loding the 2500 records suessfully but am not unable to edit and save any one ca n help
|
|
|
|
|
Have you got an edit button and save button added to the datagrid?
can you be a bit more specific with your question, how about posting a snippet of code
|
|
|
|
|
Yes i got edit button and save button.the thing is i have 2500 records and in that i update 2000 th record and am using pageing also.in my application while saving it saves 2500 record with updation record.instead of one record iam saving 2500 records.may be boz of that iam not able to save ...
|
|
|
|
|
I must say that you are doing it the wrong way Raj. For one record why should you save 2500 records? Just get that record and update that specific one. Just imagine if you have got 50000 records. What will you do then?
Ahsan Ullah
Senior Software Engineer
|
|
|
|
|
yaa ur question is right but we are in peak position we cant to update code bcoz if we update this we need to change a lot of code bcoz of that we are not doing that one......any help from ur side...
|
|
|
|
|
I hope you are using stored procedure for loading records. All you have to do is to update that store procedure a bit so that it returns required number of records only.
Ahsan Ullah
Senior Software Engineer
|
|
|
|
|
hai frnds
i have a issue regarding my webproject .i coded a smtp mail server along with options to attach images . the uploaded images are stored in a folder in web directory. while running in vb 2008 it works
but while running in iis while attaching the images a message reporting that you have no access right to upload into the folder.i try to change the access right of that folder but its not working
i m using iis 5.1 and vb 2008 and IE 5
pls help me
|
|
|
|
|
Try giving rights of asp.net to iis. If that doesn't works allow anonymous users.
Ahsan Ullah
Senior Software Engineer
|
|
|
|
|
hai
thank you for reply i would like to know how i can give access right to iis
|
|
|
|