Texpert

How do i insert multiple rows in database. for example: I have 3 list: list1: a1,a2,a3,a4 list2: b1,b2,b3,b4 list3: c1,c2,c3,c4 I want to insert a1,b1,c1 in 1st row. a2,b2,c2 in 2nd row,... How do I write one sql insert statement to do that?

Hi, I need help solving this problem. I have a dataset with four columns col1,col2,col3,col4 and the data could be col1 col2 col3 col4 ===================================== t1 abc a 1 t1 xyz a 2 t1 mnp b 3 t2 abc 1 t2 kkl 2 I want to create a datagrid which …

Hi, I am developing this app using ASP.NET 2.0, SQL Server 2005 express and VS 2005 express edition. All I am trying to do is use Login Web controls provided in ASP.NET 2.0 for my user login pages. When I go to ASP.NET configuration and click on Security tab I …

Hi, I have two drop down lists boxes, upon page load first DDL gets populated and depending on user's selection on first DDL second DDL (child DDL) gets populated, works fine. My problem is when user goes back and makes another selection on first (parent) DDL (note that it's not …

Hi, I have this app running fine on my pc with connecting to SQL server on my localhost using windows authentication. Now I am going to deploy it on my client's server where SQL Server 2K DB is on server "abcd" with SQL Server credientials (No windows authentication) My problem …

Hi, I am having problem with my Editable GridView. I am selecting columns from SQL-Server 2005 DB using a store procedure [with multiple tables in it] and then I wrote UPDATE and DELTE statements in the GridView query builder. When I run the page, Select and delete works fine but …

Hi, can someone help me to code this ? I have a dynamic datagrid and I want to insert only one column from selected [checkbox] rows in the datagrid into a SQL-Server table. I've a working code where I call Add_to_DB function within the loop of Datagrid items, which works, …

I am working on this screen, where top part of the screen is a browse/edit/add panel for table called "Package" And depending on the Package_ID (@@Identity) I am filling a datagrid in the bottom part of the same screen which has data from various other tables , like "Components" , …

Hi, in the .NET 1.1 and VB application, I am calling a store procedure [SQL-SERVER 2000] in a subroutine. the store procedure simply SELECTs rows from tables and returns data, when I try to use the data to fill the web form, it works fine until it hits any column …

Hi, I am looking for some help in coding an app using VB.NET 2003,where in a web form I have four tabs which call four different forms in the panel after click event. I don't see any tab control in the toolbox in visual studio so I guess I have …

Hi, My client has provided me number of mock ups for the web pages he wants , I am wondering is there a way of simply converting these vsd's into visual studio's web-form ? I understand I will have to click on each text-box and define the fields. But can …

Hi, I am new to ASP.NET, working on a web app using Visual Studio and VB. My App was working fine before and after I made few changes, It opens "Default.aspx" for any selection. I've even remaned the file "default.aspx" in the solution to something else and made sure there …