|
Hi Guffa.,
How to use this method (Page.ClientScript.RegisterStartupScript)& with which arguments I have to pass in the following code.
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;
public partial class Login : System.Web.UI.Page
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;data source=C:\\Project\\DataBase.mdb;Persist Security Info=False;");
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button2_Click(object sender, EventArgs e)
{
string s = "Select EmpID from Employee where EmpID=@id1;";
con.Open();
OleDbCommand cmd = new OleDbCommand(s, con);
cmd.Parameters.Add("@id1", OleDbType.VarChar);
cmd.Parameters["@id1"].Value = TextBox1.Text;
OleDbDataReader dr;
dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.Write("alert('Employee ID already Exits');");
}
else
{
string s1 = "insert into Employee values(@id1,@id2,@id3,@id4,@id5,@id6,@id7,@id8,@id9,@id10,@id11,@id12,@id13,@id14);";
con.Open();
OleDbCommand cmd1 = new OleDbCommand(s1, con);
cmd1.Parameters.AddWithValue("@id1", TextBox1.Text);
cmd1.Parameters.AddWithValue("@id2", TextBox2.Text);
cmd1.Parameters.AddWithValue("@id3", TextBox3.Text);
cmd1.Parameters.AddWithValue("@id4", TextBox4.Text);
cmd1.Parameters.AddWithValue("@id5", TextBox5.Text);
cmd1.Parameters.AddWithValue("@id6", TextBox6.Text);
cmd1.Parameters.AddWithValue("@id7", ListBox2.Text);
cmd1.Parameters.AddWithValue("@id8", TextBox7.Text);
cmd1.Parameters.AddWithValue("@id9", ListBox5.Text);
cmd1.Parameters.AddWithValue("@id10", ListBox4.Text);
cmd1.Parameters.AddWithValue("@id11", TextBox8.Text);
cmd1.Parameters.AddWithValue("@id12", BasicDatePicker1.Text);
cmd1.Parameters.AddWithValue("@id13", TextBox9.Text);
cmd1.Parameters.AddWithValue("@id14", ListBox3.Text);
cmd1.ExecuteNonQuery();
//Response.Write("alert('Inserted')");
con.Close();
}
}
private void Write(string p)
{
throw new Exception("The method or operation is not implemented.");
}
protected void ListBox1_SelectedIndexChanged(object sender, EventArgs e)
{
con.Open();
OleDbCommand cmd = new OleDbCommand("select * from Employee where EmpID=@id1", con);
cmd.Parameters.AddWithValue("@id1", ListBox1.SelectedValue.ToString());
OleDbDataReader dr = cmd.ExecuteReader();
dr.Read();
TextBox1.Text = dr.GetString(0);
TextBox2.Text = dr.GetString(1);
TextBox3.Text = dr.GetString(2);
TextBox4.Text = dr.GetString(3);
TextBox5.Text = dr.GetString(4);
TextBox6.Text = dr.GetString(5);
ListBox2.SelectedValue = dr.GetString(6);
TextBox7.Text = dr.GetString(7);
ListBox5.SelectedValue = dr.GetString(8);
ListBox4.SelectedValue = dr.GetString(9);
TextBox8.Text = dr.GetString(10);
BasicDatePicker1.DayStatusBarText= dr.GetString(11);
TextBox9.Text = dr.GetString(12);
ListBox3.SelectedValue = dr.GetString(13);
con.Close();
}
protected void Button3_Click(object sender, EventArgs e)
{
string s = "Update Employee set Pass=@id2,FName=@id3,LName=@id4,Address=@id5,HomeNo=@id6,Sex=@id7,EmailID=@id8,Designation=@id9,Education=@id10,Skills=@id11,JoinDate=@id12,CProject=@id13,PStatus=@id14 where EmpID=@id1;";
con.Open();
OleDbCommand cmd = new OleDbCommand(s, con);
cmd.Parameters.AddWithValue("@id2", TextBox2.Text);
cmd.Parameters.AddWithValue("@id3", TextBox3.Text);
cmd.Parameters.AddWithValue("@id4", TextBox4.Text);
cmd.Parameters.AddWithValue("@id5", TextBox5.Text);
cmd.Parameters.AddWithValue("@id6", TextBox6.Text);
cmd.Parameters.AddWithValue("@id7", ListBox2.SelectedValue);
cmd.Parameters.AddWithValue("@id8", TextBox7.Text);
cmd.Parameters.AddWithValue("@id9", ListBox5.SelectedValue);
cmd.Parameters.AddWithValue("@id10", ListBox4.SelectedValue);
cmd.Parameters.AddWithValue("@id11", TextBox8.Text);
cmd.Parameters.AddWithValue("@id12", BasicDatePicker1.SelectedDate);
cmd.Parameters.AddWithValue("@id13", TextBox9.Text);
cmd.Parameters.AddWithValue("@id14", ListBox3.SelectedValue);
cmd.Parameters.AddWithValue("@id1", TextBox1.Text);
cmd.ExecuteNonQuery();
//Response.Write("alert('Inserted')");
con.Close();
}
protected void Button4_Click(object sender, EventArgs e)
{
string s = "delete from Employee Where EmpID=@id1;";
con.Open();
OleDbCommand cmd = new OleDbCommand(s, con);
cmd.Parameters.AddWithValue("@id1", TextBox1.Text);
cmd.Parameters.AddWithValue("@id2", TextBox2.Text);
cmd.Parameters.AddWithValue("@id3", TextBox3.Text);
cmd.Parameters.AddWithValue("@id4", TextBox4.Text);
cmd.Parameters.AddWithValue("@id5", TextBox5.Text);
cmd.Parameters.AddWithValue("@id6", TextBox6.Text);
cmd.Parameters.AddWithValue("@id7", ListBox2.Text);
cmd.Parameters.AddWithValue("@id8", TextBox7.Text);
cmd.Parameters.AddWithValue("@id9", ListBox5.Text);
cmd.Parameters.AddWithValue("@id10", ListBox4.Text);
cmd.Parameters.AddWithValue("@id11", TextBox8.Text);
cmd.Parameters.AddWithValue("@id12", BasicDatePicker1.Text);
cmd.Parameters.AddWithValue("@id13", TextBox9.Text);
cmd.Parameters.AddWithValue("@id14", ListBox3.Text);
cmd.ExecuteNonQuery();
//Response.Write("alert('Inserted')");
con.Close();
}
}
Regards.,
Deepak
|
|
|
|
|
|
I have one form. When I took the Form to ReadOnly state all the controls in the form are need to be in readonly,
A) I have Gridview. How to make this Gridview to ReadOnly. Currently I am doing the gridview.enabled = false. It greyed out the gridview.
B) And I have some validation controls, I want to supress that validations when the form is in Readonly.
Thanks
|
|
|
|
|
A) You have to Navigate through the control Collection of the Gridview and set the property to Read-Only/ENABLED-False.
B) You have to set the Enabled property of the validation controls to false. Page has GetValidators("group") method. Check whether this helps you in some way to disable all the validation controls at once, since it returns the validators to the ValidatorCollection object.
Regards
- J O H N -
|
|
|
|
|
i am trying to update row in table (data grid ) but unable to do it .. this is what i have done so far ..
protected void UpdateCommand(object source, DataGridCommandEventArgs e)
{
Response.Write("testing");
SqlConnection conn = new SqlConnection(connectionString);
try
{
conn.Open();
string database1 = "Level1";
TextBox UserName = (TextBox)(e.Item.Cells[2].Controls[0]);
TextBox MacAddr = (TextBox)(e.Item.Cells[3].Controls[0]);
DataSet ds = new DataSet();
SqlCommand myCommand = new SqlCommand("UPDATE " + database1 +
" SET UserName = '" + UserName +
"', MacAddr = '" + MacAddr+" ' ", conn);
myCommand.Connection = conn;
myCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Response.Write(ex.Message);
Response.End();
if (conn != null) conn.Close();
return;
}
finally
{
Response.Redirect((string)Session["PreviousURL"]);
}
conn.Close();
DataGrid1.EditItemIndex = -1;
can someone help me how to update after we clik edit button in each textbox in a row ??
Thanx !!
-- modified at 11:39 Tuesday 6th November, 2007
|
|
|
|
|
rocky811 wrote: i am trying to update row in sql database
rocky811 wrote: SqlCommand myCommand = new SqlCommand("UPDATE " + database1 +
" SET UserName = '" + UserName +
"', MacAddr = '" + MacAddr+" ' ", conn);
You can't do that unless you understand the Basic's of SQL. I would reccomend you to go through the Basic's Of SQL Commands.[^]
Regards
- J O H N -
|
|
|
|
|
can u help me with the above code please ?
|
|
|
|
|
Database doesn't have rows. Only tables in the Database can contain Row's. what is that you are trying to do exactly in that code?
I have sent you a link to Read the Basic's of SQL Command. If you go through it you will understand how to write a UPDATE statement in SQL.
Regards
- J O H N -
|
|
|
|
|
sorry !! i mistyped it !!! i actually wanted to update a row in table.. i have a data grid with few columns in it . I want to edit each row and update it . when i try to click edit button it shows an exception (Invalid Operation) . Hope u got it now..
|
|
|
|
|
Here is the syntax of the UPDATE statement used to make changes to the existing records in table.
update tablename<br />
set columnname = newvalue [,columnxname = newvaluex...]<br />
where columnname OPERATOR value [and|or columnnamex OPERATOR valuex]
Compare this syntax with your UPDATE statement and check whether you have given it right.
Regards
- J O H N -
|
|
|
|
|
Dear Friends,
How we can keep data after inserting in formview controls?.
When i'm inserting a record formview will fire a method, that method is calling a stored procedure. If Stored Procedure is return error i want to keep data in my formview.
How i can solve this issue?
Haridas.R
harisofttech@gmail.com
harisofttech@hotmail.com (online)
harizeenet@yahoo.co.in(online)
"Achievement is not a destination, its a journey "
|
|
|
|
|
I think having the ViewState Enabled for ur control should solve this problem
try having the EnableViewState=true in ur FormView
or save that record in the session and take it back on return
I hope it helps
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
I am using the Ajax control toolkit TabContainer.
When I place it on the page in design view instead of seeing the Tab control I see a little brown box.
I looks fine when I run the page - it just doesnt display how it will look in the design view.
Am I doing something wrong or is it supposed to be this way ?
Thanks
|
|
|
|
|
Hello everyone,
well I'm working in a module where i'm using a gridview to display data without binding it to it. Now its working but the only problem is that it doesnt sort in alternating ASC/DESC order like normal. I noticed while debugging that I was always getting the SortDirection in the OnSorting event as Ascending.
Is there some other way so that I can make the sorting in the usual Alternating way of ASC and DESC.
Hope u got what I'm saying 
<asp:GridView ID="GridView1" runat="server" PageSize="20" DataKeyNames="DirectoryID" AutoGenerateColumns="False" AllowPaging="True"
OnPageIndexChanging="GridView1_PageIndexChanging" OnRowUpdating="GridView1_RowUpdating"
OnRowDeleting="GridView1_RowDeleting" AllowSorting="true" OnSorting="GridView1_OnSorting"
OnRowCancelingEdit="GridView1_RowCancelingEdit" OnRowCommand="EditButton_OnRowCommand">
<Columns>
<asp:TemplateField SortExpression="DirectoryID" HeaderText="DirectoryID" Visible="false">
<ItemTemplate>
<asp:Label ID="Label_ID" Text='<%# Eval("DirectoryID") %>' Runat="Server"/>
</ItemTemplate>
</asp:TemplateField>
...
and in the On sorting event I'm doin this
protected void GridView1_OnSorting(object sender, GridViewSortEventArgs e)
{
DataView dv = (DataView)Session["dvVD"];
if (dv != null)
{
//Vendor_Directory vd = new Vendor_Directory();
dv.Sort = e.SortExpression + ((e.SortDirection == SortDirection.Descending) ? " DESC": " ASC");
GridView1.DataSource = dv;
GridView1.DataBind();
}
}
Thanks in advance
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
This article[^] says that Gridview seems to have problem when we do sorting. The Value of SortDirection is always set to "Ascending". But the problem is sorted out having the sort Direction and Sort Expression in the Viewstate. Have a look, it may help you to solve the problem.
Regards
- J O H N -
|
|
|
|
|
yes definately there's something wrong here and I'm looking at this article at the moment
http://community.strongcoders.com/content/CSGridViewSortingPaging.aspx
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
YES! I did it with the help of that article I mentioned earlier...
Thanks a lot for ur help John. I appreciate it
Rocky
You can't climb up a ladder with your hands in your pockets.
|
|
|
|
|
you're most welcome.
Regards
- J O H N -
|
|
|
|
|
Hai friends,
I need to run a youtube uploaded movie to aspx page dynamically.I stored the embed tag in a sqlserver(2000)table with some label.I have a set of videos onclicking a particular name i need to run the corresponding video in aspx page.All movies are need to run in the same page itself.am using dotnet1.1 with c# coding.If anybody having idea please share and help to solve my problem...Thanks in advance
Regards
Bijesh
|
|
|
|
|
Yeah. You can show the embedded object in your aspx page but you won't be able to control the functionality of this media embedded object.That means you can't play/stop/pause the movie from code. All you can do is that you can show the different embedded media object according to what the user wanna see..
|
|
|
|
|
Hi,
Ok.control is not problem...I need to know some brief coding for this...I want to play the movies dynamically..Please help me to solve.
Regards
Bijesh
|
|
|
|
|
bijeshputhalath wrote: I want to play the movies dynamically..
As I said, you can't play/stop/pause the movie from code. What you can do is that you can show the different embedded object dynamically...
Let's say there are three buttons ( "Video1", "Video2" and "Video3") in your page. you can put those embedded script in three div.. if the user click on button1 then you can show div1 which contains the embedded script for "Video1".. If you know how to show/hide the div from Javascript, it can be done...
|
|
|
|
|
Hi,
I done with static.But my need is different.now i am briefly explain the details...
I have different products.all the products have differenet videos.(all the product details are entering in admin side including the movie tag which are stored in a table SQLSERVER2000 DB)
I shown the products in different images.while clicking the products details are displayed in another page.There is a button to watch the movie.while clicking the button the corresponing movie want to stream.while the user select the products,it shows all the details with a button to watch movie(all are comes under user side),only the corresponding movie want to run..videos are uploaded in youtube...all the products movie want to stream in the same page..My problem arises here..i can now stream only one movie,if i give the corresponding object tag.How dynamically stream the videos based on the choice without multiple buttons???Please help to solve...
i cant know how to embed object tags(movie tags )dynamically....If knows Please share me...
Thanks & Regards
Bijesh
|
|
|
|
|
Hi folks,
How to update newly cached object to the client with out any request from client.
friendly,
ranandbe
|
|
|
|
|
ranandbe wrote: How to update newly cached object to the client with out any request from client.
I'm not quiet sure about what you are asking. As far as I know a cached object will either have a dependency or time-duration, when there is a request from the client then it checks whether dependency or the duration is expired. If yes then the Cached object will get updated. You are asking How to update without any request from the client. If there's no request from the client why do you need to update the Cached object?
Regards
- J O H N -
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
