Comments by sesenyg (Top 33 by date)

yeap i did:)

Thanks for your helps:)

thanks for your attention.

i tried your datatable, dataadapter method. I realize dt is empty this time. I really don't understand, how my first sql command works fine but second returns null value??

And when i tried to dr.HasRows() method. It did not work again:(

I have two sql command one of them work fine and i used my request.querystring value on my first sqlcommand. It returns the true value.

I already try this. No rows returns. dr is empty

No, it did not:'(

Data is coming but i think the problem is datareader. It realize that it is empty.

No, it did not work again:(

I try to get data from database to write textboxes on website. TC is primary key, so it can not leave null. The code can not enter while loop , because i put a breakpoint in while loop but it did not stop anywhere.

And i can get data to my gridview 'MeasureRecord' so the problem is really not connection problem..

This is my whole code, i said the problem is not connection problem:(

SqlConnection conn = new SqlConnection();
SqlDataReader dr;
conn.ConnectionString = "server= ***; user = ***; pwd= ***; database = ***";
conn.Open();
string TCNumber = Request.QueryString["TC"].ToString();
SqlCommand comm = new SqlCommand("SELECT Sistolic,Diastolic,Pulse,Date from

MeasureRecords WHERE TC='"+TCNumber+"'");
SqlDataAdapter adap = new SqlDataAdapter(comm);

comm.Connection=conn;
DataSet ds = new DataSet();
adap.Fill(ds);

MeasureRecord.DataSource = ds;
MeasureRecord.DataBind();

SqlCommand comm2 = new SqlCommand("SELECT TC, Name, Surname, BirthDate, Phone from Pers_Info WHERE TC='"+TCNumber+"'");
comm2.Connection = conn;
dr = comm2.ExecuteReader();

while (dr.Read())
{
TCNo.Text = dr["TC"].ToString();
Name.Text = dr["Name"].ToString();
Surname.Text = dr["Surname"].ToString();
BirthDate.Text = dr[3].ToString();
Phone_Number.Text = dr[4].ToString();
}
dr.Close();
dr.Dispose();
conn.Close();

No, unfortunatelly it is not, i did not add my connection lines there. The problem is not connection problem:(

Thank you so much dude:)

No, it is impossible. I have to leave it string. Is there anyway to compare a string in select-where query?

Actually, my parameter TC is string which i used in sql command. Firstly, i try to do
string TCNumber = Request.QueryString["TC"].ToString();
SqlCommand comm = new SqlCommand("SELECT Sistolic,Diastolic,Pulse,Date from MeasureRecords WHERE TC= @TCNumber;", conn);

but it gave me errors, so i change the data type. I think the first problem is my data TC on database is a string but i try to match it with an int.

No, it did not work. It said the same thing again:(

Thank you for your solution it helped me but now it says "the conversion of the varchar value '4577765884' overflowed an int column." Do you know what is this?

I find the problem, thanks:)

thanks a lot:)

QueryString method solved my problem. Thanks:))

Thanks dude:)

thanks:)

Thank you, it solved problem perfectly:)

hi,
I write this code like your advise but the code could not find the address.
Can you explain more detailed?
this is my code

string X = dr[0].ToString();
Response.Redirect("ETC.aspx?Data=X ");

First of all thanks of your interest but i have already put + signs to my code. Moreover, barneyman answer my question. Thanks:)

actually you are so right, now i understood the problem. It made me crazy for 2 days. Thank you so muchhh!!!!