Set connection string in SqlDatasource

Code :

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:connectionString_Name %>"
SelectCommand="proc_name" SelectCommandType="StoredProcedure"></asp:SqlDataSource>

Done :)

Comments

show image in asp.net form from database

In order to show image from database to webform first add an image control in webpage. <asp:Image ID="imgStudentImage" runat="server" Height="157px" Width="160px" /> Then add new webform to read image from database for example displayimage.aspx and in code behind model write the following code. public string str = //your string public SqlConnection conn; public SqlCommand sql = new SqlCommand(); public SqlDataReader dr; public string strSQL; protected void Page_Load(object sender, EventArgs e) { conn = new SqlConnection(str); conn.Open(); long id = Convert.ToInt64(Request.QueryString["mId"]); strSQL = ""; strSQL = strSQL + " SELECT snap from S...

Export Doc,Access,Image,CSV,Excel,Pdf,XML,HTML,Text,Print of Gridview in Asp.net

First import itextsharp.dll in the solution and use three namespces (basically for pdf) using iTextSharp.text; using iTextSharp.text.pdf; using iTextSharp.text.html.simpleparser; Then Use the following code :- on each button click protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BindGridDetails(GridView1); } } protected DataTable BindGridDetails(GridView GridView1) { ...

im2col function in MATLAB explanation

Let us suppose we have A=[1 1;2 2] 1 1 2 2 ... ok Now img2col syntax == im2col(A,[m n],block_type) Where block type = ('distinct','sliding') distinct places 0's in the final output,,,for padding, sliding,,repeats from the very first matrix element. after all elements read out. Now.. Now [m n] -- very important .... Number of Rows to show = M*N (if m=2 ,, n=2 then each column has 4 elements..) and Number of element fetch to repeat is M in row... That means,, OUTPUT OF THIS - im2col(A,[2 2], 'sliding') ans = 1 2 1 2 -- if A=[1 1 1;2 2 2] A = 1 1 1 2 2 2 then im2col(A,[2 2], 'sliding') ans = contains 4 rows....as 2*2 ... and fetch 2 elements as M=2 here... and slidin...

Solve Code

Search This Blog