TechnicalSky: August 2013

Saturday, 31 August 2013

# create a multifile assembly

Þ 1.create a .cs file say <function.cs> which stores only static function.

Þ 2.create another file inside which you placed your main funtion say <hello.cs>(reference with namespace used if used.)

Þ 3. firstly , create a .net module: csc /t:module function.cs

Þ 4. secondly, csc /addmodule:function.netmodule /out:start.exe hello.cs

11:43 PM 28/08/2013

Tuesday, 20 August 2013

Display Image (path stored in database ) in gridView using Asp.net

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="DisplayImages1.aspx.cs" Inherits="GrudViewImage.DisplayImages1" %>

<!DOCTYPE html>

</head>

<body>

<div>

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="Id" DataSourceID="SqlDataSource1">

<asp:BoundField DataField="Id" HeaderText="Id" ReadOnly="True" SortExpression="Id" />

<asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" />

<asp:BoundField DataField="image" HeaderText="image" SortExpression="image" />

<asp:ImageField DataImageUrlField="image" ControlStyle-Width="100"

ControlStyle-Height = "100" HeaderText = "Preview Image"/>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:GridViewImageExampleConnectionString %>" SelectCommand="SELECT * FROM [GridViewImage]"></asp:SqlDataSource>

</div>

</form>

</body>

</html>

Some Queries using Language integrated Query ( LINQ ).

Let Us perform some queries using Linq:

1. Retrieve all records from database

sampleDataContext sdc = new sampleDataContext();

//var data = from d in sdc.ToyShops select d ;(retrieve all records)

var data = from d in sdc.ToyShops select new { id=d.toyId,name=d.toyname};// retrieve selected column

dataGridView1.DataSource = data;

2. Update records from database

sampleDataContext sdc = new sampleDataContext();

ToyShop ts = sdc.ToyShops.Single(c => c.toyId == Convert.ToInt32(textBox1.Text));

ts.toyname = textBox2.Text;

sdc.SubmitChanges();

MessageBox.Show("records Updated successfully !!");

3. Delete records from database

sampleDataContext sdc = new sampleDataContext();

ToyShop ts = sdc.ToyShops.Single(c => c.toyId == Convert.ToInt32(textBox1.Text));

sdc.ToyShops.DeleteOnSubmit(ts);

sdc.SubmitChanges();

MessageBox.Show("records deleted successfully !!");

4. Delete records from database

sampleDataContext sdc = new sampleDataContext();

ToyShop ts = new ToyShop();

ts.toyId = Convert.ToInt32(textBox1.Text);

ts.toyname = textBox2.Text;

sdc.ToyShops.InsertOnSubmit(ts);

sdc.SubmitChanges();

MessageBox.Show("data inserted successfully ");

5. Skip() and Take()

sampleDataContext sdc = new sampleDataContext();

var data = (from d in sdc.ToyShops select d).Skip(1).Take(2);

dataGridView1.DataSource = data;

6. Generate Computable fields using Linq

sampleDataContext sdc = new sampleDataContext();

//var data = from d in sdc.ToyShops select d ;(retrieve all records)

var data = from d in sdc.ToyShops select new { id = d.toyId, name = d.toyname,price=d.price,quantity=d.nofQuantity,netPrice=d.price*d.nofQuantity };

dataGridView1.DataSource = data;

Note :
Where Toyshop is the name of the Table in your database .

Retrieve all records from database

sampleDataContext sdc = new sampleDataContext();

//var data = from d in sdc.ToyShops select d ;(retrieve all records)

var data = from d in sdc.ToyShops select new { id=d.toyId,name=d.toyname};// retrieve selected column

dataGridView1.DataSource = data;

Datagrid Binding implementation with selected column:

On Page_Load:

Var data=from d in <dbmlFileContextObj>.tableName select d;

Just set :

this.dataContext=d;

after setting context come on markup code:

<DataGrid.Columns>

</DataGrid.Columns>

</DataGrid>