If you cant debug in ur web service

Hi ,

This is realy nice web site for debug error in Webservice

http://visualbasic.about.com/od/usingvbnet/a/WSDebug.htm

Cheers
malith

X- Mass Comming soon

Hi All,

X-mas season is comming soon. Father Christmas will bring lots of gifts for all of us. Hurray! X-mass season has started. Now we can go shopping and Buy all kinds of items.

please remeber One thing my dear friends, we are in happy season but a Group of people (who are our Brothers and Sisters) sacrifies their lifes for our country. We are Called them "Our Heros" .Dont forget our "HEROS".

please gaiv them a hand if want to help our heros!!!!!!!!


Cheers
Casper

How Connect the Access DB Using OLEDB VB.net

Hi All,

This is Sample code for connect Access DB . I think this is very useful to Beginners

Dim conStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\\Test1.mdb"
Dim DBConn As OleDbConnection = New OleDbConnection
DBConn.ConnectionString = conStr
Dim DA As OleDbDataAdapter = New OleDbDataAdapter
Dim DS As DataSet = New DataSet

Try
DBConn.Open()
DA = New OleDbDataAdapter("Select * from emp", DBConn)
DA.Fill(DS, "test")
DataGridView1.DataSource = DS.Tables(0)

Catch ex As Exception

Finally
DBConn.Close()

End Try

how to edit GridView inASP .net 2.0

Hi All

please read this web , this is really good one.

http://msdn.microsoft.com/en-us/library/ms972948.aspx

thanks
Casper

How to join with two or more tables

SELECT
A simple SELECT statement is the most basic way to query multiple tables. You can call more than one table in the FROM clause to combine results from multiple tables. Here’s an example of how this works:


SELECT table1.column1, table2.column2 FROM table1, table2 WHERE table1.column1 = table2.column1;


or


SELECT table1.column1, table2.column2 FROM table1, table2, table3 WHERE table1.column1 = table2.column1 AND table1.column1 = table3.column1;

How to CREATE PROCEDURE

CREATE PROCEDURE Add_User

@fname varchar(50),
@lname varchar(50),
@emailaddress varchar(50),
@password varchar(50),
@address varchar(50),
@telehome varchar(50),
@telemobile varchar(50),
@nicNo varchar(50)

AS

insert into Customer (fname ,lname,emailAddress,pwd,address,telehome,telemobile,nicno)

values(@fname,@lname,@emailaddress,@password,@address,@telehome,@telemobile,@nicNo)

GO

How to insert data through SQL Server Stored Procedures

This is sample code for insert using SP

sqlConn.Open();
SqlCommand sqlCmdAddCustomer = new SqlCommand("Add_User", sqlConn);
sqlCmdAddCustomer.CommandType = CommandType.StoredProcedure;
SqlParameter p1 = new SqlParameter("@fname", this._fName);
SqlParameter p2 = new SqlParameter("@lname", this._lName);
SqlParameter p3 = new SqlParameter("@emailAddress", this._eMialAdd);
SqlParameter p4 = new SqlParameter("@password", this._passWord);
SqlParameter p5 = new SqlParameter("@address", this._address);
SqlParameter p6 = new SqlParameter("@telehome", this._teleHome);
SqlParameter p7 = new SqlParameter("@telemobile", this._teleMobile);
SqlParameter p8 = new SqlParameter("@nicno", this._nicNo);

sqlCmdAddCustomer.Parameters.Add(p1);
sqlCmdAddCustomer.Parameters.Add(p2);
sqlCmdAddCustomer.Parameters.Add(p3);
sqlCmdAddCustomer.Parameters.Add(p4);
sqlCmdAddCustomer.Parameters.Add(p5);
sqlCmdAddCustomer.Parameters.Add(p6);
sqlCmdAddCustomer.Parameters.Add(p7);
sqlCmdAddCustomer.Parameters.Add(p8);

sqlCmdAddCustomer.ExecuteNonQuery();
sqlConn.Close();

How to work with SP

This is the sample codes working with ASP .net and SP

sqlConn.Open();
sqlCmd = new SqlCommand("Get_customer_Details",sqlConn);
sqlCmd.CommandType = CommandType.StoredProcedure;
dataReader = sqlCmd.ExecuteReader();

DataTable dtTable = new DataTable();
dtTable.Columns.Add("Name");
dtTable.Columns.Add("Email Address");
DataRow row;

int no = 0;

while(dataReader.Read())
{
row = dtTable.NewRow();
row["Name"] = dataReader.GetString(0).Trim();
row["Email Address"] = dataReader.GetString(1).Trim();
dtTable.Rows.Add(row);

}

no = dtTable.Rows.Count;

totemail.Text = no.ToString();

DataGrid1.DataSource = dtTable;

// or You can set the dataset
/*
DataTable dt = new DataTable();
DataSet ds = new DataSet();
ds.Tables.Add(dt);
*/
DataGrid1.DataBind();

*Two moon on 27 August*

Hi All,

I got a news. Please let me know this is correct or not.

this is the News , I got

*27th Aug the Whole World is waiting for......... ....*

Planet Mars will be the brightest in the night sky starting August. It will look as large as the full moon to the naked eye. This willculminate on Aug. 27 when Mars comes within 34.65M miles of earth. Be sureto watch the sky on Aug. 27 12:30 am. It will look like the earth has 2 Moons. The next time Mars may come this close is in 2287.

Thanks
Casper.

1890 Ceylon photos

Hi Friends.

I got my friend's email. it was a good link. I think it will be usefull for my friends.

Please visit this link : 1890 Ceylon photos

Thanks
Casper

Keep It mind

hi friends

Do u like this pattern ?

07-07-07 07:07:07

it is comming soon .. Pl keep it mind this day. dont miss that .:D

Thanks
Malith

Wish u a Happy New Year

Hi My friends.

I wish u a Happy new Year.

From
Malith