Comments by Raajendran (Top 30 by date)

thank u sunil....
but i need the text value and i need to store that text in DB...
Using that i need to give authentication for different users...
so i need to get the Text of LinkButtons

Hi Dude.. Thank u... that your Updated Query executing...

Thnak u dude..

In Sql Its gives the ErrorMessageg Like this for my below Query

SELECT CASTE(Canadd) BIT FROM Tbl_Com_UserRights

Thanks for this information dude...

its getting error because of that xmlns part in that code u provided

Hi,.. thnak u So much for Your information...
i have 1 doubt ..

how to retrieve the values from Database to Gridview Again...

what ll be the value in gridview & checkbox?

error is

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

how to combine that numeric value with checkbox checked value...

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

Thank U So Much Prabakaran...

Thank U So Much Sarrrva...

Thank U So Much....

I Got Solution....

Thanks alot....

Thank u... Fine its Working...

IIF(IsNUll(Salary), 0.0, Salary)

i have another one problem also...

in sql am using IsNull() ... how to use this in MS Access

like...

SELECT IsNull(Sum(Salary),0.00) FROM Tbl_Employee WHERE Month='June'

How to use this function here...

K Thank U...

Thank u So much...

if me retrieving more than one value means How to write..?


Select EmpName,Empcode,CONVERT(varchar,DOB,103)as DOB FROM Tbl_Employee

thank u so much, without ajax control can i get date in textbox?

thanks dude...
in design created two logins in flash...
so i need to take two logins..

i dono how to rate

Thank U friend...

Thank u so much...

Thank u so much...

if am using two login pages means then how to do that...


in admin page i have 4 admin/Parent logins ..

in student login page i have more no of student logins..

how is it possible...




my innerpage is a master page


in that master page,,

if admins logged in from their login (admin login) page means .., i need to show all the links


if students logged in from their login page means i need to hide some links...

Query1 = "SELECT P.Id,P.regno,P.StdName, P.ClassSection,A.Standard, A.Description, A.Fee FROM Tbl_Sc_StudentProfile P INNER JOIN Tbl_Sc_Feeallocation A ON P.Standard = A.Standard where not exists (select c.description,c.class from Tbl_Sc_FeeCollChild c Where c.class = P.classsection and c.stdid = P.Id and c.description=A.Description) group by A.Description,P.Id,P.regno,P.StdName,P.ClassSection, A.Standard , A.Fee order by Standard asc";
da = new SqlDataAdapter(Query1, con);
ds = new DataSet();
dt = new DataTable();
da.Fill(ds, "Tbl_Sc_StudentProfile");
dt = ds.Tables["Tbl_Sc_StudentProfile"];
foreach (DataRow row1 in dt.Rows)
{
con.Open();
Query2 = "INSERT INTO dummytbl VALUES('" + row1[0] + "','" + row1[1] + "','" + row1[2] + "','" + row1[3] + "','" + row1[4] + "','" + row1[5] + "','" + row1[6] + "')";
cmd = new SqlCommand(Query2, con);
cmd.ExecuteNonQuery();
con.Close();
}

in this while run,... inserting 1783 rows successfully in table dummytbl..
after that am the error below


sqlexception was unhandled by user code
Incorrect syntax near 'S'.

Thank U So Much...

Query1 = "SELECT P.Id,P.regno,P.StdName, P.ClassSection,A.Standard, A.Description, A.Fee FROM Tbl_Sc_StudentProfile P INNER JOIN Tbl_Sc_Feeallocation A ON P.Standard = A.Standard where not exists (select c.description,c.class from Tbl_Sc_FeeCollChild c Where c.class = P.classsection and c.stdid = P.Id and c.description=A.Description) group by A.Description,P.Id,P.regno,P.StdName,P.ClassSection, A.Standard , A.Fee order by Standard asc";
da = new SqlDataAdapter(Query1, con);
ds = new DataSet();
dt = new DataTable();
da.Fill(ds, "Tbl_Sc_StudentProfile");
dt = ds.Tables["Tbl_Sc_StudentProfile"];
foreach (DataRow row1 in dt.Rows)
{
con.Open();
Query2 = "INSERT INTO dummytbl VALUES('" + row1[0] + "','" + row1[1] + "','" + row1[2] + "','" + row1[3] + "','" + row1[4] + "','" + row1[5] + "','" + row1[6] + "')";
cmd = new SqlCommand(Query2, con);
cmd.ExecuteNonQuery();
con.Close();
}










this is my code sir...
in this only am getting error after 1783 rows inserted

i'm new to this sir... so i don't know...

Thank u so much sir..
can u tell how to write parameterized query..