Web Development

10-Jan-07 20:01

Hi everyone,
I'm having with selecting a row in a datagrid. I have a datagrid that is ment to update and it runs very well, But I don't want the user to keep scrolling when ever they want to update so I created a textbox(txtname) and a button where a user is supposed to write a name and by the click of the button the corresponding row is selected. Now where the problem is it's that when I write a name say Ndayahundwa,Claude and press button I get this error:
Incorrect syntax near 'Ndayahundwa'. Here is the code I'm using:

SqlCommand myCommand = new SqlCommand();
myCommand.Connection=con;
myCommand.CommandText="select * from isp_email.staff where @fullname like%" +txtname.Text+ "%";
SqlParameter myparam = new SqlParameter("@fullname",SqlDbType.Text);
myparam.Value=txtname.Text;
myCommand.Parameters.Add(myparam);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
dgupdate.DataSource=ds;
dgupdate.DataBind();
Could some one bail me out?
Thanks.

Paddy Boyd10-Jan-07 23:19

10-Jan-07 23:19

This line:

nclauder wrote:
myCommand.CommandText="select * from isp_email.staff where @fullname like%" +txtname.Text+ "%";

Should be written as:

"select * from isp_email.staff where fullname like @fullname"

and add the % signs to the ends of your parameter. This is providing that fullname is a field in your table.

nclauder11-Jan-07 0:13

11-Jan-07 0:13

Thanks Paddy,
I tried it but it couldn't work but I tried this and it could only bring the header text do you think i'm missing something?

SqlCommand myCommand = new SqlCommand("select * from isp_email.staff where fullname Like '"+@txtname+"'",con);
SqlParameter myparam = new SqlParameter("@txtname",SqlDbType.Text);
myparam.Value=txtname.Text;
myCommand.Parameters.Add(myparam);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
con.Open();
dgupdate.DataSource=ds;
dgupdate.DataBind();
con.Close();
Thanks again.

Paddy Boyd11-Jan-07 0:17

11-Jan-07 0:17

You've got the wrong end of this - this is not how SQL parameters work. They are not concatenated into the text, e.g.:

<br />
SqlCommand myCommand = new SqlCommand("select * from staff where fullname Like @txtname",con); <br />
<br />
SqlParameter myparam = new SqlParameter("@txtname",SqlDbType.Text);<br />
<br />
myparam.Value= "%" + txtname.Text + "%"; <br />
<br />
myCommand.Parameters.Add(myparam);<br />
<br />
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);<br />
<br />
DataSet ds = new DataSet();<br />
myAdapter.Fill(ds); <br />

You also seem to be opening your connection after the call to myAdapter.Fill?

nclauder11-Jan-07 0:41

11-Jan-07 0:41

Thanks very much it has actually worked though when a column is selected and I press edit, It first brings back the whole table and I have to press again ok and it comes back in the editable stile. but it Edits properly.
do you think there is something wrong or thats how it's supposed to be?
thanks

Paddy Boyd11-Jan-07 0:43

11-Jan-07 0:43

That doesn't sound quite right, but without more details it's hard to say...

nclauder11-Jan-07 1:13

11-Jan-07 1:13

here is a datagrid that is supposed to edit and previously I was creating where a user can be able to select a name and update one row by one. But this time it makes a lomg process like I've just explain the user will press ok afteg writing the name the row will be selected as expected and when the edit is pressed the whole table appears with the 1st row on teh table in motion of being edited, but when the user presses ok for the second time the column that is supposed to be edited will be selected in the write form of being edited and the user will edit it will be edited properly. I don't Understand Why When the user presses edit the whole table appears. If this can not help let me show you how the code goes.

private void bttok_Click(object sender, System.EventArgs e)
{

SqlCommand myCommand = new SqlCommand("select * from isp_email.staff where fullname Like @txtname",con);
SqlParameter myparam = new SqlParameter("@txtname",SqlDbType.Text);
myparam.Value="%"+txtname.Text+"%";
myCommand.Parameters.Add(myparam);
SqlDataAdapter myAdapter=new SqlDataAdapter(myCommand);
DataSet ds = new DataSet();
myAdapter.Fill(ds);
con.Open();
dgupdate.DataSource=ds;
dgupdate.DataBind();
con.Close();

}
public void Edit_dgupdate(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgupdate.EditItemIndex = e.Item.ItemIndex;
BindDataGrid();
}
public void Cancel_dgupdate(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
dgupdate.EditItemIndex = -1;
BindDataGrid();
}
public void Update_dgupdate(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
System.Web.UI.WebControls.DropDownList st=new System.Web.UI.WebControls.DropDownList();
st=(System.Web.UI.WebControls.DropDownList)e.Item.Cells[2].FindControl("ddlst");
System.Web.UI.WebControls.TextBox stl=new System.Web.UI.WebControls.TextBox();
stl=(System.Web.UI.WebControls.TextBox)e.Item.Cells[1].Controls[0];
System.Web.UI.WebControls.TextBox stf=new System.Web.UI.WebControls.TextBox();
stf=(System.Web.UI.WebControls.TextBox)e.Item.Cells[0].Controls[0];
string dll = st.SelectedItem.Value;
SqlCommand myCommand=new SqlCommand();
myCommand.Connection=con;
myCommand.CommandText="update isp_email.staff set stafflevel=@stafflevel where ID=@id";
myCommand.Parameters.Add(new SqlParameter("@stafflevel",SqlDbType.Char,45));
myCommand.Parameters["@stafflevel"].Value=st.SelectedValue;
myCommand.Parameters.Add(new SqlParameter("@id",SqlDbType.Char,45));
myCommand.Parameters["@id"].Value=stl.Text;
myCommand.Parameters.Add(new SqlParameter("@Name",SqlDbType.Char,45));
myCommand.Parameters["@Name"].Value=stf.Text;
con.Open();
myCommand.ExecuteNonQuery();
con.Close();
dgupdate.EditItemIndex=-1;
BindDataGrid();
}
Thanks

Paddy Boyd11-Jan-07 1:19

11-Jan-07 1:19

If txtName is a textbox within a row in the datagrid, you won't be able to access it this way?

nclauder11-Jan-07 1:29

pagging code in php like yahoo mail inbox

11-Jan-07 1:29

txtname is a textbox that is on the web form and it's supposed to refer to a textBox in the datagrid. is there some thing wrong?
Thanks

kumar bharat bhusanam10-Jan-07 18:39

kumar bharat bhusanam

10-Jan-07 18:39

I want pagging code ( of search results ) in php like in tahoo mail inbox
for exp ( 3 records out of 120 first previ next last ) this should be come instade of page numbers. plz help me

Bharat Bhusanam

IE7 setAttribute On Dynamicly Created Elements

Zane.Kellogg10-Jan-07 8:45

Zane.Kellogg

10-Jan-07 8:45

I am dynamically creating elements (divs to be specific) and wish to add on onmouseover event to the element before I add it to the page. What I have so far is basically this:

// Create New Div
var newDiv = document.createElement('div');

// Add ID
newDiv.id = myID;

// Add CSS and innerHtml
newDiv.className = 'myBox';

// Add Attribute NOTE: Does Not Work in IE
newDiv.setAttribute("onmouseover", "myFunction('" + myID + "')";

// Add Div to document
document.body.appendChild(newDiv);

This works perfectly well in Firefox and Opera, but when it comes to IE7, no dice. Any suggestions?

I've also tried this:
myDiv.onmouseover = "myFunction(" + myID + ");";

Also to no avail.

thanks

IIS - executing an external application

hssaroch10-Jan-07 2:42

hssaroch

10-Jan-07 2:42

Hi,

I am building an ASP.NET(2) app and am using IIS(6) on W2K3. In one of my pages I need to call an external executable (pass it some arguments and get the result back). But when I run the webapp, the program doesn't execute. On debugging it says "Access not allowed".

I doubt it's not ASP.Net issue rather an IIS issue but am not sure. I tried almost every thing I could find through Google but no good. Any help in this regard would be highly appericiated.

Here is the code I wrote:

<br />
        Process proc = new Process();<br />
        string file = @"Bin\kuma.exe";<br />
        proc.StartInfo.FileName = file;<br />
        proc.StartInfo.Arguments = "arg1 arg2 arg3";<br />
        proc.StartInfo.UseShellExecute = false;<br />
        proc.StartInfo.RedirectStandardInput = false;<br />
        proc.StartInfo.RedirectStandardOutput = true;<br />
        proc.StartInfo.CreateNoWindow = true;<br />
        proc.Start();<br />
<br />
        /* Read proc output ... */<br />
        StreamReader output = proc.StandardOutput;<br />
        string txt = output.ReadToEnd();<br />
        Trace.Write("txt" + txt);<br />

Thanks and regards.

Marcus J. Smith10-Jan-07 2:45

Marcus J. Smith

10-Jan-07 2:45

You must give permission to the process that is running the website such as IUSR_<machinename> to the location of the executable.

Cleako

hssaroch10-Jan-07 2:51

hssaroch

10-Jan-07 2:51

Hi,

I have already tried this. Also I have allowed "all unkonwn cgi extensions" in web services extensions tab in IIS manager but to no avail.

TCHamilton13-Feb-09 6:22

TCHamilton

13-Feb-09 6:22

Did you ever get this solved?

I have an ASP.NET that needs to create some files on the server, then zip them up and send them to the client. Do you have any suggestions?

Thank you

Tom