I have a grid which i bind with values from Database. I have events to edit and update the grid. I am not using SqlDatasource to connect to DB. Rather i am doing the updating of the grid Programmaticall y.
I have 3 columns, LID(item template column) ,LVal (Edit Item template column) and Edit link
My Question:
1) My EditITemTemplat e column has a textbox txt_Lval which does not show up on the page load. But if click...
User Profile
Collapse
-
Grid view Edit Item Template column not visible.
Last edited by Curtis Rutland; Jul 28 '08, 03:38 PM. Reason: Added Code Tags - Please use the # button -
Named Ranges Find and Update
1) I have a Namedrange which is named Company in sheet 2.
Sheet 1 cell A2 has a list created via data validation referencing to this sheet 2 Column A values.
2) If i go to Name Manager (by doing a Ctrl+f3) on the name manager window the formula will be =Sheet2!$A$2:$A $6
3) I am using Microsoft.Offic e.Interop.Excel component.
4) Now on my .net application i want to find a namerange in sheet 1 with a particular name like... -
I got the answer for my Question.
I declared a temp table. Inserted into temp table DDLName from tbl_dropdownlis t and ordered them. Inserted into temp table LValue from tbl_ListValues and ordered them. Select * from "temp table name".... -
Sql Inner Join/Union
I have two tables tbl_Dropdownlis t and tbl_ListbValues
tbl_Dropdownlis t has fol. Columns.
DDLid -PK
DDLName
tbl_ListValues has fol. columns.
ListValueId
DDlid – FK
LValue
On my result set I need DDLname from tbl_Dropdownlis t & LValue associated with DDLName in tbl_ListValues.
if try a inner join query like "select tbl_Dropdownlis t.DDLName,ListV alues.LValue... -
Handling output Sqlparameter
Hi,
I am trying to retrieve a value from database, based on that value I want to insert records into DB.Let’s say I am retrieving tsmid which serves as the output parameter in the stored procedure.
.net/C# code is
...Code:public void getTSmid() { int tsid=0; tsid = System.Convert.ToInt32(SqlHelper.ExecuteReader(SqlHelper.tConnectionString, CommandType.StoredProcedure,
No activity results to display
Show More
Leave a comment: