sys is undifined and type is undifiend

http://www.kodyaz.com/blogs/software_development_blog/archive/2008/01/03/768.aspx

Get column name from one table

SELECT [name] AS [Column name]

FROM syscolumns

WHERE id = (SELECT id

FROM sysobjects

WHERE type = 'U'

AND [NAME] = 'product')

Get Filename from Directories and store in Datatable

private void button1_Click(object sender, EventArgs e)

{

string[] filename=Directory.GetFiles("D:\\Deepa\\AgentAgroFarms\\");

for (int i = 0; i <> {

string a=(filename[i]);

file += a.Replace("D:\\Deepa\\AgentAgroFarms\\","")+",";

}Publish Post

file = file.Substring(0, file.LastIndexOf(",") - 1);

DataTable tbl_filename = new DataTable();

tbl_filename.Columns.Add("filename",typeof(string));

DataRow dr=tbl_filename.NewRow();

dr[0]=file;

}

Get value from Row Command C#

//get value from linkbutton commandArgument isbn id

string isbn =Convert.ToString( e.CommandArgument);

Session["Inventory_ISBN"].ToString = isbn;

//get value from hidden filed

LinkButton btnedit = (LinkButton )(e.CommandSource);

HiddenField hf = (btnedit.Parent.FindControl("vendorid_hidden")) as HiddenField;

Session["Inventory_vendorid"] = Int32.Parse(hf.Value);///Datekey value

Update data in Gridview

http://www.webswapp.com/categories/ASPNET2/DropDownList_GridView/default.aspx

GET VALUE FROM DROPDOWNLIST

string ContentName = e.Values["ContentName"].ToString();         
         
// Get Value from DropDown
int TopicID = 0;
foreach (DetailsViewRow row in ItemsDetailsView.Rows)
{
    if (row.Cells[0].Text == "Topic")
    {
         DropDownList TopicDropDown = (DropDownList)row.Cells[1].FindControl("Topic_TopicIDList");
         TopicID = int.Parse(TopicDropDown.SelectedValue.ToString());
    }

}

xml format

private bool fnBulkInsFilterISBN(DataTable dt, string sPID, ref string sErrorMessage)

{

bool blnResult = false;

DataSet ds = new DataSet();

if (dt != null)

{

ds.Tables.Clear();

ds.Tables.Add(dt.Copy());

ds.Tables[0].TableName = "InventoryDetails";

dt = ds.Tables[ds.Tables[0].TableName];

if (dt.Rows.Count > 0)

{

System.Text.StringBuilder sb = new System.Text.StringBuilder(1000);

System.IO.StringWriter sw = new System.IO.StringWriter(sb);

foreach (DataColumn col in dt.Columns)

{

col.ColumnMapping = MappingType.Attribute;

}

ds.WriteXml(sw, System.Data.XmlWriteMode.WriteSchema);

SqlConnection ConVMSServer;

SqlCommand cmdVMSInsertlog;

ConVMSServer = new SqlConnection(strServerConnection);

if (ConVMSServer.State == ConnectionState.Closed) { ConVMSServer.Open(); }

int intRecordsAffected = 0;

try

{

cmdVMSInsertlog = new SqlCommand("Usp_VMSInvSearchBulkInsert", ConVMSServer);

cmdVMSInsertlog.CommandTimeout = 0;

cmdVMSInsertlog.CommandType = CommandType.StoredProcedure;

cmdVMSInsertlog.Parameters.AddWithValue("@ID", sPID);

cmdVMSInsertlog.Parameters.AddWithValue("@empdata", SqlDbType.NText).Value = sb.ToString();

intRecordsAffected = cmdVMSInsertlog.ExecuteNonQuery();

if (intRecordsAffected > 0) { blnResult = true; }

}

catch (Exception ex)

{

SetErrorMsg(ex.Message);

}

finally

{

if (ConVMSServer.State == ConnectionState.Open) { ConVMSServer.Close(); }

ConVMSServer.Dispose();

}

}

}

return blnResult;

}