manju: February 2012

Wednesday 22 February 2012

storing text documents in the folder and the file path in the database

1 .first create the folder to store the documents
here i created folder with name "documents"

2 after that create table in database like this

and in code behind

string FileName = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
//Save images into Images folder
FileUpload1.SaveAs(Server.MapPath("documents/" + FileName));
//Getting dbconnection from web.config connectionstring

//Open the database connection
con.Open();
//Query to insert images path and name into database
SqlCommand cmd = new SqlCommand("Insert into testing(ImageName,ImagePath) values(@ImageName,@ImagePath)", con);
//Passing parameters to query
cmd.Parameters.AddWithValue("@ImageName", FileName);
cmd.Parameters.AddWithValue("@ImagePath", "documents/" + FileName);
cmd.ExecuteNonQuery();
//Close dbconnection
con.Close();

Monday 20 February 2012

Procedure to bind checkboxlist control

public void chkboxlist()
{
SqlDataAdapter da = new SqlDataAdapter("select SE_Category from category", con);
DataTable dt = new DataTable();
da.Fill(dt);
CheckBoxList1.DataSource = dt;
CheckBoxList1.DataTextField = "SE_Category";
CheckBoxList1.DataValueField = "SE_Category";
CheckBoxList1.DataBind();
CheckBoxList1.Items.Insert(0, "Others");
}

Thursday 9 February 2012

Importing data from text fles/notepad into database

BULK
INSERT table_name
FROM 'C:\Documents and Settings\manju\Desktop\test.txt'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

Monday 6 February 2012

Most hardest thing is to change the default view of the DropDown LIst. here is the simple CSS for that