Adding css effect to gridview while you mouse over and out from gridview

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
e.Row.Attributes["onmouseover"] = "this.className='PostingPanelTableGrids';"
e.Row.Attributes["onmouseout"] = "this.className='PostingPanelTableGrid';";
}

Coding for checking status of ip with ping statment in asp.net with c#

string server_ip = "127.0.0.1";//address to verify, like 127.0.0.1
Ping _objPing = new Ping();
PingReply reply_ping;
reply_ping = p.Send(server_ip);
int ping_success = 0, ping_insuccess = 0;
for (int i = 0; i < 25; i++)
{
reply_ping = _objPing.Send(server_ip);
if (reply_ping.Address.ToString() == server_ip)
ping_success++;
else
ping_insuccess++;
Console.WriteLine("Pack. sent");
}
Console.WriteLine("sent = 4, recived = {0}, lost = {1}", ping_success, ping_insuccess);
Console.ReadKey();

Coding for show child gridview in gridview row

protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{
GridViewRow row = (GridViewRow)(((Button)e.CommandSource).NamingContainer);
Button b1 = (Button)row.FindControl("Button1");
GridView g1 = (GridView)row.FindControl("GridView2");
if (b1.Text == "Show")
{
g1.Visible = true;
b1.Text = "hide";
}
else if (b1.Text == "hide")
{
g1.Visible = false;
b1.Text = "show";
}
}

upload and download file from sqlserver

Creating sqlserver table

create table (id int,content_type varcahr(50),filename varcahr(50),filecontent varbinary(8000))


Code for c#.net



using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.IO;

public partial class filestore : System.Web.UI.Page
{
SqlConnection ObjSQlConnectionString = new SqlConnection("Data source=server_name;Initial Catalog=table_name;User Id=userid;Pwd=password");

protected void btn_upload_file_Click(object sender, EventArgs e)
{


string upload_path_name = upload.PostedFile.FileName.ToString();
string upload_file_name = Path.GetFileName(upload_path_name);
FileStream Upload_filestream = new FileStream(upload_path_name, FileMode.Open, FileAccess.Read);
BinaryReader upload_binaryreader = new BinaryReader(Upload_filestream);
Byte[] byte_data = upload_binaryreader.ReadBytes ((Int32)Upload_filestream.Length);
upload_binaryreader.Close();
Upload_filestream.Close();

if (upload.PostedFile.ContentType == "application/vnd.ms-excel")
{
//upload file in a seperate folder
upload.SaveAs("C:\\Inetpub\\wwwroot\\tools_test\\excel files\\"+upload_file_name);
}

Response.Write(byte_data.Length);


//insert data in sqlserver table

string insert_query = "insert into filestroage(content_type,filename,filecontent)values(@content_type,@filename,@filecontent)";

SqlCommand sql_command = new SqlCommand(insert_query, ObjSQlConnectionString);

sql_command.CommandType = CommandType.Text;

sql_command.Parameters.Add("@content_type", SqlDbType.VarChar).Value = upload.PostedFile.ContentType.ToString();
sql_command.Parameters.Add("@filename", SqlDbType.VarChar).Value = upload_file_name;
sql_command.Parameters.Add("@filecontent", SqlDbType.Binary).Value = byte_data;

ObjSQlConnectionString.Open();

sql_command.ExecuteNonQuery();

ObjSQlConnectionString.Close();

}

//Read files data from table
protected void Button1_Click(object sender, EventArgs e)
{
string strQuery = "select content_type,filename,filecontent from filestroage where id=@id";

SqlCommand sql_command = new SqlCommand(strQuery);

sql_command.Parameters.Add("@id", SqlDbType.Int).Value = 2;

DataTable data_table_query = GetData_table(sql_command);

if (data_table_query != null)
{
file_download (data_table_query);
}
}



private DataTable GetData_table(SqlCommand sql_command)
{
DataTable data_table = new DataTable();

SqlDataAdapter sql_adapter = new SqlDataAdapter();

sql_command.CommandType = CommandType.Text;

sql_command.Connection = ObjSQlConnectionString;

try
{
ObjSQlConnectionString.Open();

sql_adapter.SelectCommand = sql_command;

sql_adapter.Fill(data_table );

return data_table;

}

catch
{

return null;

}

finally
{

ObjSQlConnectionString.Close();

sql_adapter.Dispose();

ObjSQlConnectionString.Dispose();

}

}

//Download read data in their own file format
private void file_download(DataTable data_table_rows)
{

Byte[] data_bytes = (Byte[])data_table_rows.Rows[0]["filecontent"];

Response.Buffer = true;

Response.Charset = "";

Response.Cache.SetCacheability(HttpCacheability.NoCache);

Response.ContentType = data_table_rows.Rows[0]["content_type"].ToString();

Response.AddHeader("content-disposition", "attachment;filename="+ data_table_rows .Rows[0]["filename"].ToString());

Response.BinaryWrite(data_bytes);

Response.Flush();

Response.End();
}
}

Playing with simple Interface Concept

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace ConsoleApplication1
{
class Program:interface_first ,interface_second
{

public static void Main()
{
Console.WriteLine("INTERFACE TEST\n");

//call by class objects.
Program call_interface_first = new Program();
call_interface_first.method_for_interface("Invoke first interface method using object of first class");
call_interface_first.methos_for_second_interface("Invoke second interface method using object of first class\n");

second_calss call_interface_second = new second_calss();
call_interface_second.method_for_interface("Invoke first interface method using object of second class\n");



interface_first first_interface_call = call_interface_first;
first_interface_call.method_for_interface("Call the first interface using interface object with assing class objects");
interface_second second_interface_call = call_interface_first;
second_interface_call.methos_for_second_interface("Call the second interface using interface object with assing class objects\n");

//call by same interface objects.
interface_first call_using_interface_refference = new Program();
call_using_interface_refference.method_for_interface("call first interface using the same interface reference");
interface_first call_using_interface_refference1 = new second_calss();
call_using_interface_refference1.method_for_interface("call second interface using the same interface reference\n");

//call by interface array with same reference.
interface_first[] array_interface = { new Program(), new second_calss() };
for (int i = 0; i <= 1; i++)
{
array_interface[i].method_for_interface("Invoke interface methods from class in array format :" + i);

}

}

public string method_for_interface(string i)
{

Console.WriteLine(i.ToString());
return i;
}
public string methos_for_second_interface(string s)
{
Console.WriteLine(s.ToString());
return s;
}

}

interface interface_first
{
//void interface_method_first();
string method_for_interface(string i);

}
interface interface_second
{
string methos_for_second_interface(string s);
}

//second class for accessing Interface
class second_calss : interface_first
{
public string method_for_interface(string s)
{
Console.WriteLine(s.ToString());
return s;
}
}
}

Code for sending sms from C# using way2sms api

Before Write a code use the steps given below

1. Add Web References to your page.
In that web references page just type this "http://www.spiritssoft.com/webservice/sendway2sms.asmx" in url optoin and click go

After Added that

2. use the name space Using com.spiritssoft.www

3. create a object for sending a sms
SendWay2Sms Objsms_send = new SendWay2Sms();

4.write the code given below here

Note: If you send to a single number just write the code what given here.If you want to send more than one person use comma(,) to seperate the numbers.


For sending one number:

String Strsms_result=Objsms_send.sendSmsSpiritsSoft("UserName", "Password", "Number", "message");

For sending more than numbers:

String Strsms_result=Objsms_send.sendSmsSpiritsSoft("UserName", "Password", "Number 1,Number 2,Number 3", "message");

Coding for Accessing Sub Directory file with authentication mode as Forms using a web config file

IF u have a single Folder you should write the given code below

Code in a Web Config Root File

Note: when u use this code Just ignore to type Double quotes with the tags.

"<" configuration ">"
"<" location path="Your first sub directory folder Name" ">"
"<" system.web ">"
"<" authorization ">"
"<" allow users="*" "/>"
"<"/ authorization ">"
"<"/ system.web ">"
"<"/ location ">"
"<"/ configuration ">"

If you have more than one folder write the code given below

"<" configuration ">"

"<" location path="Your first sub directory folder Name" ">"
"<" system.web ">"
"<" authorization ">"
"<" allow users="*" "/>"
"<"/ authorization ">"
"<"/ system.web ">"
"<"/ location ">"

"<" location path="Your Secondary sub directory folder Name" ">"
"<" system.web ">"
"<" authorization ">"
"<" allow users="*" "/>"
"<"/ authorization ">"
"<"/ system.web ">"
"<"/ location ">"

"<"/ configuration ">"

Creating custom Server Control

write this coding in Web Control Library Form

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace my_first_control
{
[DefaultProperty("Text")]
[ToolboxData("<{0}:WebCustomControl1 runat=server>")]
public class WebCustomControl1 : System.Web.UI.WebControls.WebControl,INamingContainer
{
protected TextBox new_textbox = new TextBox();
protected Button button = new Button();

The Below Strings are Displayed Default in a cs file.Am attached the meaning for the terms below....

[Bindable(true)]----specifies for visual designers whether it is meaningful to bind the property to data

[Category("Appearance")]----specifies how to categorize the property in the visual designer's property browser

[DefaultValue("")]----specifies a default value for the property

[Localizable(true)]----specified as true or false, specifies for visual designers whether it is meaningful to localize the property.

public string Text
{
get
{
String s = (String)ViewState["Text"];
return ((s == null) ? String.Empty : s);
}

set
{
ViewState["Text"] = value;
}
}
public override ControlCollection Controls
{
get
{
EnsureChildControls();//EnsureChildControls method checks if CreateChildControls is already called, and call it if not
return base.Controls;
}
}
protected override void CreateChildControls()
{
//base.CreateChildControls();

Controls.Clear();
new_textbox.ToolTip = "User Created Control";
new_textbox.Text = "NEW CREATED TEXT BOX";

button.Click += new EventHandler(button_Click);

Controls.Add(new_textbox);
Controls.Add(new LiteralControl("
"));
Controls.Add(button);
Controls.Add(new LiteralControl("
"));
}
private void button_Click(object sender, EventArgs e)
{
EnsureChildControls();
new_textbox.Text = "TEXT WORKS";
}
public override void RenderControl(HtmlTextWriter writer)
{
base.RenderControl(writer);
}

protected override void OnInit(EventArgs e)
{
string javascript_code_data = @"";
Page.RegisterClientScriptBlock("my script", javascript_code_data);
base.OnInit(e);
}
}
}

Build the Form as Dll.It Stores in Project Foldrename-->Debug-->Bin-->Filename.dll
add the dll reference to ur page.

We have Two type to Register the Control into our Web From
1. Using Register Namesapace="my_frist_Control" Assembly="My_First_Control" TagPrefix="vijay" with in the tag "<%@Register %>"

2. Add this web Config File.If u Register in web Config File.You need not to Register in Each File.You can use the control in Different File.
system.web
pages
controls
add tagPrefix="mycontrol" namespace="my_first_control" assembly="my_first_control"/
/controls
/pages
/system.web

Then Call the tag name in Web form as

mycontrol:WebCustomControl1 ID="my_control" runat="server"

It Will Show your Control on your Web Form.

Query for creating store procedure for running dynamic table with single Procedure

create procedure select_table_dynamic @table_name nvarchar(1000) as
Declare @table nVarchar(1000)
set @table = 'select * from ' + @table_name
exec(@table)

Run Store Procedure

Exec  select_table_dynamic 'table_name'

Coding for Export Sqlserver Data into Excel

Before go in for export,just configure ur Database Driver With the Given Code Below.

EXEC sp_configure 'show advanced options', 1;

GO
RECONFIGURE;
GO
EXEC sp_configure 'Ad Hoc Distributed Queries', 1;
GO
RECONFIGURE;
GO

While Run a below code U must create a xls file in a give path,and specify the header in that file.

Below Code is used to Export Sql Data into Excel Format

INSERT INTO
  OPENROWSET( 'Microsoft.Jet.OLEDB.4.0',
  'Excel 8.0;Database=C:\testing.xls',
  'select fname, lname, email, dateadd, lastchgd, firsttimeuser, active from sql4.ctsi.dbo.users where custno=0913 and active=Y
 FROM [Sheet1$]')

  select fname, lname, email, dateadd, lastchgd, firsttimeuser, active from sql4.ctsi.dbo.users where custno='0913' and active='Y'