Comments by 07navneet (Top 60 by date)

hey I am working on MS-VS2008(3.5)

thanks for the reply. but this also didnt work. there is an interesting thing that ajax is not running on my PC but the same code works fine in my friend's laptop! Both of us have got ajaxcontroltoolkit.dll(3.5.11119.0)

changed the color and scriptmanager BUT...same problem!!

!!?? already told you its not working? is there something i need to change in web.config file?

how come color combination effect this?? now i have removed colors but same problem persists!

still the same problem!!!

sorry! doesnt effect!!

@martin-cud u explain a bit more?

did you mean to type 'ping smtp.gmail.com' in cmd prompt??

no!

print mistake!

thanks! it will not happen again.

same error again!! do i have to some thing in web.config also?

sorry! didnt work, same error thrown.

mam, may i know why?

dude, please paste your final solution. please!!

It would be better if you explain with an example.

to be precise, hide.

Mine is a stored procedure(MS-SQL) and you are giving me syntax for writing code in .cs file!

no, its not updating! After entering new(edit) value I am fetching the text of 'txtname.text' into dummy textbox but new value is not been fetched into dummy!

public void BindData()
{
con.Open();
SqlCommand cmd1 = new SqlCommand();
cmd1.Connection = con;
cmd1.CommandText = "GetInfo";
cmd1.CommandType = CommandType.StoredProcedure;
//SqlDataReader rdr = cmd1.ExecuteReader();
//gv2.DataSource = rdr;
SqlDataAdapter da = new SqlDataAdapter(cmd1);
DataSet ds = new DataSet();
da.Fill(ds);
gv2.DataSource = ds;
gv2.DataBind();
cmd1.Dispose();
con.Close();
}

no error thrown!

expecting answer from you sir!

Is this correct for Edit button?
public void edit(object sender, GridViewEditEventArgs e)
{
gv1.EditIndex = e.NewEditIndex;
BindData();
}

point #3 could be the posibl error! But how to handle/remove it.

still having trouble!!

I have done like this:
int.TryParse((gv1.Rows[e.RowIndex].Cells[2].Text), out phone);
and then
cmd1.Parameters.Add("@s_phone", SqlDbType.Int).Value = phone;
Now I am not getting error but table is not updated. Also phone gets value=0!

Also, other values from cells are not showing their corr. values! What to do??

Also, other values from cells are not showing their corr. values!

Also, other values from cells are not showing their corr. values!

I am getting zero!

zero!

I have done like this:
int.TryParse((gv1.Rows[e.RowIndex].Cells[2].Text), out phone);
and then
cmd1.Parameters.Add("@s_phone", SqlDbType.Int).Value = phone;
Now I am not getting error but table is not updated.

I have done like this:
int.TryParse((gv1.Rows[e.RowIndex].Cells[2].Text), out phone);
and then
cmd1.Parameters.Add("@s_phone", SqlDbType.Int).Value = phone;

Now I am not getting error but table is not updated.

I am not able to check! But if it contains illegal characters then what is the solution?

this much logic I know!! but how to implement(code) it??

But I want to delete the row using "AutoGenerateDeleteButton" and don't want to take value from a textbox.

why would i use textbox to delete a row in gridview??

One more help, sir. I am learning ASP.NET by myself but not able to cope up with such problems. What should be the way to learn and master this, so that job will not be a matter for me in 2012?

!!!!!!!!!! You are really a MVP, sir!
Caught the error in one shot! I was struggling with this type of problem since a month but couldn't find answer! I thought about this answer but I guessed that this is the syntax for procedure.
Thanks a lot!!!

???

If its so simple then how??

The parameters are filled(I am not able to show to you the 'print screen' image at time of debugging) with their corr.values

Sorry! But getting same result. Also my previously asked question was also unsolved and till now I am not able to perform DML operations(insert/update/delete) using ASP.NET.
I am about to give up with ASP.NET!!

Sir, is there a problem in my PC, due to which its not executing this code properly??

Please help, somebody!

Stored Procedure:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[getdata]
as
begin
select*from emp
end

I have tried it but didnt work!

<connectionstrings>
<add name="nav" connectionstring="server=mainserver;uid=quibusjpr_g;pwd=1234;initial catalog=Navneet_01" providername="system.data.sqlclient">

@Bala-i have made the connection string in web.config and called it on page by-ListView's sqldatasource:-
<connectionstrings>
<add name="nav" connectionstring="server=mainserver;uid=quibusjpr_g;pwd=1234;initial catalog=Navneet_01" providername="system.data.sqlclient">

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:nav %>"
SelectCommand="SELECT * FROM [Nav_Bulletins]">

i hv cnctd to right DB thats why insertion of records is taking place in DB but error is coming just after inserting record.

if i make it null then permanently it stores value as NULL in table...

no it was not passed null.

After putting brk point:-

+cmd {System.Data.SqlClient.SqlCommand}
-commandParameters {System.Data.SqlClient.SqlParameter[3]}
+[0] {@Bulletin} System.Data.SqlClient.SqlParameter
+[1] {@Url} System.Data.SqlClient.SqlParameter
+[2] {@IsActive} System.Data.SqlClient.SqlParameter
commandText "Nav_Bulletins_Insert" string
commandType StoredProcedure System.Data.CommandType
+connection {System.Data.SqlClient.SqlConnection}
retval 0 int