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;

}

sql Factorial

DECLARE @Fact TABLE(Nums INT)
INSERT INTO @Fact
SELECT 0 UNION ALL
SELECT 1 UNION ALL
SELECT 3 UNION ALL
SELECT 5 UNION ALL
SELECT 10

SELECT * FROM @Fact
--Solution :
DECLARE @Fact TABLE(Nums INT)
INSERT INTO @Fact
SELECT 0 UNION ALL
SELECT 1 UNION ALL
SELECT 3 UNION ALL
SELECT 5 UNION ALL
SELECT 10

DECLARE @no INT,@f BIGINT,@nums INT

DECLARE C1 CURSOR FOR SELECT nums FROM @fact
OPEN C1
FETCH NEXT FROM C1 INTO @no
WHILE @@FETCH_STATUS=0
BEGIN
SELECT @f=1,@nums=@no
WHILE @no>0
BEGIN
SET @f=@f*@no
SET @no=@no-1
END
DECLARE @t TABLE(nums INT,Fact BIGINT)
INSERT INTO @T SELECT @Nums,@F
FETCH NEXT FROM C1 INTO @no
END
CLOSE C1
DEALLOCATE C1

SELECT * FROM @T ORDER BY 1

Abstract and interface

An Interface cannot implement methods.
An abstract class can implement methods.

An Interface can only inherit from another Interface.
An abstract class can inherit from a class and one or more interfaces.

An Interface cannot contain fields.
An abstract class can contain fields.

An Interface can contain property definitions.
An abstract class can implement a property.

An Interface cannot contain constructors or destructors.
An abstract class can contain constructors or destructors.

An Interface can be inherited from by structures.
An abstract class cannot be inherited from by structures.

An Interface can support multiple inheritance.
An abstract class cannot support multiple inheritance.