Archive for Giugno 27th, 2008

Reporting

CodeKeep C# Feed Giugno 27th, 2008

Description: SQL Reporting Services

Link: http://www.codekeep.net/snippets/2842c9e2-d540-489c-9ef4-a22be21ed550.aspx

Custom Function:
Dim InvNo as integer =0
Function GetInvNo(InvoiceNo as integer)
If(InvNo=0)
 InvNo = InvoiceNo
Else
 InvNo = InvNo + 1
End If
return InvNo
End Function

Calling Reports
ASPX.CS
btn_Click()
{
....
Url.Append("<Script language='javascript'>");

Url.Append("OpenReport('" + reportserverurl + "')");

Url.Append("</Script>");

ClientScript.RegisterStartupScript(typeof(Page), "Url", Url.ToString());

}


Javascript ASPX
function OpenReport(Path)

{

RptObj=window.open(Path,"Report", "width=750,height=600,left=25,resizable=yes,top=25,screenX=" +window.screenLeft+",screenY=" +window.screenTop+",scrollbars=yes");

RptObj.focus();

}

Inserting data thru Views

CodeKeep C# Feed Giugno 27th, 2008

Description: Inserting data thru Views

Link: http://www.codekeep.net/snippets/28815537-005c-40d5-b452-b31bee393306.aspx

select * from test1
select * from test

insert into test1 values ('a')

alter view tstView

as

select distinct T.[Name],T.[No] from test T,test t1 where T.[name] = t1.[name]

 

select * from tstview

insert into tstview ([name],[no]) values('fd',18)

Attributes

CodeKeep C# Feed Giugno 27th, 2008

Description: Adding attributes

Link: http://www.codekeep.net/snippets/551344a8-c0a9-41ea-963e-7144ca57f0e9.aspx

<body id="bodyHomePage" Runat="Server">

And then in your Page_Load do something like this:

bodyHomePage.Attributes.Add("onLoad", "alert('Welcome visitor')")

<%=string%>

ArrayList ListBox

CodeKeep C# Feed Giugno 27th, 2008

Description: ListBox population from XML

Link: http://www.codekeep.net/snippets/f2a539eb-e663-453d-870d-7b203d189cb1.aspx

private void button2_Click(object sender, EventArgs e)

{

IsDataSet = false;

DataSet ds = new DataSet();

ds.ReadXml("http://www.eggheadcafe.com/rss.xml");

DataTable dt = ds.Tables[2];

ArrayList al = new ArrayList();

string thename;

string thevalue;

foreach (DataRow row in dt.Rows)

{

thename = (string)row["title"];

thevalue = (string)row["link"];

al.Add (new CustomItem(thename,thevalue)); 

}

listBox1.DataSource =al; 

}

Events and Delegates

CodeKeep C# Feed Giugno 27th, 2008

Description: Code sample

Link: http://www.codekeep.net/snippets/fbdaa254-1727-4421-92c4-f1656a0d9360.aspx

using System;

using System.Collections.Generic;

using System.Text;

namespace testclass

{

public class Ram_Class

{

private int XX =20;

private int YY = 10;

public delegate int mycal(int zz, int qq);

public event mycal myevent;

static void Main(string[] args)

{

testclass.Ram_Class obj = new testclass.Ram_Class();

obj.Sum(2, 2);

}


public int sum

{

get

{

throw new System.NotImplementedException();

}

set

{

}

}

public int Sum(int xx, int yy)

{

myevent += new mycal(add);

myevent(2, 3);

return (this.XX + this.YY);

}

public int add(int zz, int qq)

{

//zz = this.XX;

//qq = this.YY;

return (zz-qq);

}

public int multiplication(int aa, int bb)

{

aa = this.XX;

bb = this.YY;

return (aa * bb); 


}

}

}

Merge Different Datatable in one

CodeKeep C# Feed Giugno 27th, 2008

Description: This code allows to merge two different datatable into one datatable with the common Id field

Link: http://www.codekeep.net/snippets/7750345b-e751-4a45-8b0d-a2e542d9c517.aspx

  public DataTable MergeTables(DataTable dtFirst, DataTable dtSecond, string CommonColumn)
                {
                    DataTable dtResults = dtFirst.Clone();
                    int count=0;
                    for (int i = 0; i < dtSecond.Columns.Count; i++)
                        {
                    if (!dtFirst.Columns.Contains(dtSecond.Columns[i].ColumnName))
                        {
                            dtResults.Columns.Add(dtSecond.Columns[i].ColumnName, dtSecond.Columns[i].DataType);
                            count++;
                            }
                        }

                    DataColumn []columns = new DataColumn[count];
                    int j = 0;
                    for (int i = 0; i < dtSecond.Columns.Count; i++)
                    {
                    if (!dtFirst.Columns.Contains(dtSecond.Columns[i].ColumnName))
                    {
                    columns[j++] = new DataColumn(dtSecond.Columns[i].ColumnName, dtSecond.Columns[i].DataType);
                    }
                    }

                        dtResults.BeginLoadData();
                        foreach(DataRow dr in dtFirst.Rows)
                        {
                        dtResults.Rows.Add(dr.ItemArray);
                        }
                            foreach(DataRow dr in dtSecond.Rows)
                            {
                                foreach(DataRow dr1 in dtResults.Rows)
                                {
                                    if(dr1[CommonColumn].ToString().Equals(dr[CommonColumn].ToString()))
                                    {
                                        foreach(DataColumn c in columns)
                                        {
                                        dr1[c.ColumnName] = dr[c.ColumnName];
                                        }
                                    }
                                }
                            }
                dtResults.EndLoadData();
                return dtResults;
            }