rony001

I have a text box , Combo box and a dgv in a form . I want to insert text box input and Combo box selected item into dgv. combo box is bound to database table column. can someone provide me with a link or sample code? Thanks

I am new to sql server .I have recently downloaded Sqlserver 2008 and connected from vb.net . I am trying to create dynamic tables with two columns such as name,amount by passing table names from text box . CREATE TABLE " & TblName & "( [Name] TEXT(10), [Amount] TEXT(6))] table1 …

I am new to c# .I am having trouble to add a datagridview in the below code. can someone tell me how to do it? thanks using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Data.SqlServerCe; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace _35c { public partial class …

hello friends I have two tables with column A and column B. I want to update column B of table2 with column B of table1 . I have trying this query in ms access from Vb.net. update table1 t1 LEFT JOIN table2 t2 on t1.a = t2.a SET t2.b = …

hello friends I am trying to convert a vb.net datagridview code into asp.net. I want to display last three rows of table column from database table in gridview column1. Dim dt As New DataTable ' Create columns dt.Columns.Add("column1", Type.GetType("System.String")) dt.Columns.Add("column2", Type.GetType("System.String")) dt.Columns.Add("column3", Type.GetType("System.String")) dt.Columns("column3").Expression = "[column1]+[column2]" dt.Rows.Add("", "") dt.Rows.Add("", "") …

I have an Access Database on which I have tables with similar structure and columns name columnA and columnB.I can use the below query on tables created design time to get this output. Table | result -------|-------- SELECT "Table1" AS Table, SUM(a) - SUM(b) AS Result FROM table1 UNION SELECT …

I have the following sql query in vb.net and ms access , how do I create a table from the query result ? `SELECT 'Table1' AS [Table], SUM(a) - SUM(b) AS Result FROM table1 union all union all SELECT 'Table2' AS [Table], SUM(a) - SUM(b) AS Result FROM table2 I …

hello friends I am new to asp.net. does anyone has any sample code of text box on how to limit inputs into four digits and move to next text box and auto decimal if anyone has a code or knows a good tutorial on how to ,please let me know …

hello friends I have three tables with similer structure and same column name id,sname,ssno,grade. I want to copy rows from table1 to table2 and table3 based on column grade . I am getting an error No value given for one or more required parameters. can someone kindly tell me how …

hi I want to list all tables in sql server compact 3.5 database and total of a specific column (I have a column name "total" in all tables).when i run the code I get no error but it does not work. can some tell me what is wrong with the …

hi friends I am trying to search a table with last and first name and update table after changes .I can retrieve rows and display in datagridview, I would like to know how do I update table after changes, i would appreciate any help Private Sub TextBox1_TextChanged(ByVal sender As System.Object, …

I am not a programmer just learning. I would like to know how to save the scheme info into a table ? I have this sql statement that seems to work but how do i save the info into a table Dim CmdStr As String = " SELECT TABLE_NAME FROM …

how to create a pop up form for each row in datagridview that holds detailed info about that particular row of a column ? I want a editable pop up form with two text boxes and sum of both text boxes in the selected cell of the column . i …

I am new to using html. I have been going around in circles for hours to find where to put my image in the script ?the script disdisplays a frame of picture with broken link .I found I can add pictures like below but I am trying to learn how …

I am new to vb.net, I want the first column of the unbound datagridview to have defult value such as item1,item2. item3 on form load event . I would appriciate if someone tell me how to add defult values in a column like this and save all three rows in …

I am new to vb.net , in a project i have a form containing one combobox and two text box nameing as account displaying all accounts name in table , first text box as debit and textbox as credit . I can insert text box entry in the first combobox …

I am new to sql .please help me with this . the following sql statement works when i use like this Dim' CmdStr As String = "insert into table1(id,name,ref,amount) select id,name,ref,amount from table where name = A" I want to copy rows from one table into multiple tables Dim CmdStr …