- Upvotes Received
- 0
- Posts with Upvotes
- 0
- Upvoting Members
- 0
- Downvotes Received
- 1
- Posts with Downvotes
- 1
- Downvoting Members
- 1
13 Posted Topics
Sir, I have following codes <?php $country=""; $capital=""; if (isset($_POST['submit'])) { $country=$_POST['text1']; $capital=$_POST['text2']; echo '<script type="text/javascript">alert("The capital of " .$country. "is " . $capital)</script>'; } if (isset($_POST['clear'])) { $country=""; $capital=""; } ?> <html> <head><title>Result on same page</title> </head> <body> <center> <form name="form1" action="same_browser.php" method="post"> Country<input type="text" name="text1" value="<?php echo $country;?>"><br> …
Dear Sir, I have following codes <?php $var2=""; $name=""; if (isset($_POST['button1']) && !empty($_POST['text1'])) { $name=$_POST['text1']; if ($name=="1") { $var2="1"; }else{ $var2="0"; } } ?> <html> <head> <title> First form </title> </head> <body> <form name="aa" action="textboxes.php" method="Post"> First<input type="text" name="text1" value=""><br> Second<input type="text" name="text2" value="<? echo $var2; ?>" disabled><br> <input type="submit" …
Dear Sir, I have modified your codes once again as <?php if (isset($_POST['button1'])){ $name=$_POST['text1']; }else{ $name=""; } if ($name) { echo 'My name is ' . $name; }else{ echo 'No name entered'; } ?> <html> <head> <title> First form </title> </head> <body> <form name="aa" method="POST"> Name <input type="text" name="text1" value=""> …
[QUOTE=padtes;1114074]Given relational database normalization, you should not do that. What you do is join Sale and Code tables in your select statement. However for some reason you do want to update the SALE table, just for sake of it here is SQL that works in MS SQL. Nothing to do …
Dear Developers SQL, Table1 has data as following Code------product 1-----------Mango 2-----------Potato 3-----------Orange Datagridview has THREE columns as Code----product-------qty I have following codes [CODE]str3 = "SELECT product FROM table where code =" & Val(DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(0).Value) dt3 = GetTable3(str3) If dt3.Rows.Count > 0 Then DataGridView1.Rows(DataGridView1.CurrentRow.Index).Cells(1).Value = (IIf(IsDBNull(dt3.Rows(0).Item("product")), "", dt3.Rows(0).Item("product"))) Else MsgBox("Code Not Found", …
I have following codes [CODE] str2 = "select sno,name from employees where sno =" & Val(Me.TextBox1.Text) cmd2 = New SqlClient.SqlCommand(str2, con) da2 = New SqlClient.SqlDataAdapter(cmd2) dt2 = New DataTable da2.Fill(dt2)[/CODE] Now dt2 has two columns as sno and name But I want to add a 3rd column city type char(80) …
Dears [CODE] Private Sub DataGridView1_CellLeave(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellLeave If e.ColumnIndex = 0 And e.RowIndex = 0 Then MsgBox("this is first coulmn") End IfEnd Sub [/CODE] IF cursor leaves column 0 and row 0 then it displays msgbox but I want to check where column …
Hello Sqlserver MyTable has following data Vou---------date---------qty 1-------25/12/2009------5 2-------25/12/2009------4 1-------26/12/2009------8 2-------26/12/2009------3 3-------26/12/2009------2 [CODE] str = "SELECT date, SUM(Qty) AS Qty, FROM mytable GROUP BY Date" dt = GetTable(str) [/CODE] These codes display following result date--------------qty 25/12/2009------9 26/12/2009------13 Now I want to add sno column in result as Sno--------date---------qty 1------25/12/2009------9 2------26/12/2009------13 …
Hello good Teachers I have a datagridview with 3 columns. the second column is a read only . When I leave column 1 I would like to go directly to column 3. For this, I got following codes from somewhere but I need these codes in vb.net format, please help …
Hello Everyone Sqlserver Table1 has following data Sno---------date---------qty 1-------25/12/2009------5 2-------25/12/2009------4 1-------26/12/2009------8 2-------26/12/2009------3 3-------26/12/2009------2 I want to get following result Sno---------date---------qty 2-------25/12/2009------9 3-------26/12/2009------13 That is grouping on date. Column1 =count date Column2 =date Column3=sum of qty What command should I write to get above result Please help
[QUOTE=itzshaheer;1109220]When I type some data on text box and click the button 'Save' in db only storing the word in the SQL command like like that. There is no error messages . What you think. Can you help me[/QUOTE] Is there any error message?
Dear Developers How to enable "Autio Hide" command for Solution Explorer Window Please Help
Datagridview has three columns as code-----name------country 1--------Eric--------Germany 2---------Bill--------France I want to apply code like these [CODE] If e.ColumnIndex = 2 Or e.KeyValue = Keys.Left Then SendKeys.Send("{RightArrow}") End If [/CODE] These are not correct codes, I need modification Reason: When cursor is in column3 (country) and user press LEFT arrow key …
The End.