Asp.Net Programming

Tuesday, 12 March 2013

Delete Particular or Selected Row from Datatable in Asp.net

We can delete datatable rows by using delete method for that check below code

C# Code

DataTable dt1 = new DataTable();

dt1 = ds.Tables[0];

for (int i = 0; i < dt.Columns.Count;i++ )

{

if (i == 3)

{

dt.Rows[i - 1].Delete();

dt.AcceptChanges();

}

VB.NET Code

Dim dt1 As New DataTable()

dt1 = ds.Tables(0)

For i As Integer = 0 To dt.Columns.Count - 1

If i = 3 Then

dt.Rows(i - 1).Delete()

dt.AcceptChanges()

End If

How to select/deselect checkboxes in gridview

How to Check or UnCheck Checkboxes in Asp:gridview

Introduction:

In this article I will explain how to select/deselect all the checkboxes in gridview using JavaScript.

Description:

I have a one gridview with checkboxes here my requirement is if I select header checkbox of gridview I need to select all the child checkboxes in gridview and if I deselect header checkbox I need to deselect all the child checkboxes in gridview and if I select all the child checkbox I need to select the header checkbox and if any child checkbox deselected I need to deselect header checkbox for this I have written JavaScript function to achieve this functionality.

Design your aspx page like this

<title>Check/Uncheck all the Checkboxes in Gridview</title>

// Select/Deselect checkboxes based on header checkbox

function SelectheaderCheckboxes(headerchk) {

debugger

var gvcheck = document.getElementById('gvdetails');

var i;

//Condition to check header checkbox selected or not if that is true checked all checkboxes

if (headerchk.checked) {

for (i = 0; i < gvcheck.rows.length; i++) {

var inputs = gvcheck.rows[i].getElementsByTagName('input');

inputs[0].checked = true;

}

//if condition fails uncheck all checkboxes in gridview

else {

for (i = 0; i < gvcheck.rows.length; i++) {

var inputs = gvcheck.rows[i].getElementsByTagName('input');

inputs[0].checked = false;

}

//function to check header checkbox based on child checkboxes condition

function Selectchildcheckboxes(header) {

var ck = header;

var count = 0;

var gvcheck = document.getElementById('gvdetails');

var headerchk = document.getElementById(header);

var rowcount = gvcheck.rows.length;

//By using this for loop we will count how many checkboxes has checked

for (i = 1; i < gvcheck.rows.length; i++) {

var inputs = gvcheck.rows[i].getElementsByTagName('input');

if (inputs[0].checked) {

count++;

}

//Condition to check all the checkboxes selected or not

if (count == rowcount-1) {

headerchk.checked = true;

}

else {

headerchk.checked = false;

}

</script>

</head>

<body>

<div>

<asp:GridView ID="gvdetails" runat="server" DataSourceID="dsdetails" onrowdatabound="gvdetails_RowDataBound" >

<asp:TemplateField>

<asp:CheckBox ID="chkheader" runat="server" onclick="javascript:SelectheaderCheckboxes(this)" />

</HeaderTemplate>

<asp:CheckBox ID="chkchild" runat="server"/>

</ItemTemplate>

</asp:TemplateField>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="dsdetails" runat="server" ConnectionString="<%$ConnectionStrings:dbconnection %>"

SelectCommand="select * from UserInfo" >

</asp:SqlDataSource>

</div>

</form>

</body>

</html>

After completion of aspx page design write the following code in codebehind

protected void gvdetails_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

CheckBox headerchk = (CheckBox)gvdetails.HeaderRow.FindControl("chkheader");

CheckBox childchk = (CheckBox)e.Row.FindControl("chkchild");

childchk.Attributes.Add("onclick", "javascript:Selectchildcheckboxes('" + headerchk.ClientID + "')");

}

After that set your database connection in web.config like this because we are using this connection in our sqldatasource to get the data from database

</connectionStrings >

Friday, 8 March 2013

How to upload/download file from FTP Server in Asp.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.IO;

using System.Net;

public partial class Default2 : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

}

// Upload file

protected void btnUpload_Click(object sender, EventArgs e)

{

//fileName = Name of the file to be downloaded from FTP server.

string fileName = "test.txt";

//filePath = The full path where the file is to be created. Here i put local system path.

string filePath = "C:\\FTP";

string ftpServerIP = "IP Address";

string ftpUserID = "User ID";

string ftpPassword = "Password";

FtpWebRequest reqFTP;

try

{

FileStream outputStream = new FileStream(filePath + "\\"+ fileName, FileMode.Create);

reqFTP = (FtpWebRequest)FtpWebRequest.Create(newUri("ftp://" + ftpServerIP + "/" + fileName));

reqFTP.Method = WebRequestMethods.Ftp.DownloadFile;

reqFTP.UseBinary = true;

reqFTP.Credentials = new NetworkCredential(ftpUserID, ftpPassword);

FtpWebResponse response = (FtpWebResponse)reqFTP.GetResponse();

Stream ftpStream = response.GetResponseStream();

long cl = response.ContentLength;

int bufferSize = 2048;

int readCount;

byte[] buffer = new byte[bufferSize];

readCount = ftpStream.Read(buffer, 0, bufferSize);

while (readCount > 0)

{

outputStream.Write(buffer, 0, readCount);

readCount = ftpStream.Read(buffer, 0, bufferSize);

}

ftpStream.Close();

outputStream.Close();

response.Close();

}

catch (Exception ex)

{

string errMsg = (ex.Message);

}

// Download file

protected void btnDownload_Click(object sender, EventArgs e)

{

string filename = "c:\\test.txt";

string ftpServerIP = "IP address";

string ftpUserID = "User ID";

string ftpPassword = "Password";

FileInfo fileInf = new FileInfo(filename);

string uri = "ftp://" + ftpServerIP + "/" + fileInf.Name;

FtpWebRequest reqFTP;

// Create FtpWebRequest object

reqFTP = (FtpWebRequest)FtpWebRequest.Create(newUri("ftp://" + ftpServerIP + "/" + fileInf.Name));

//Provide ftp userid and password

reqFTP.Credentials = new NetworkCredential(ftpUserID, ftpPassword);

// By default KeepAlive is true, where the control connection is not closed

// after a command is executed.

reqFTP.KeepAlive = false;

//Specify the command to be executed. Here we use upload file command

reqFTP.Method = WebRequestMethods.Ftp.UploadFile;

//data transfer type we use here is binary

reqFTP.UseBinary = true;

// Notify the server about the size of the uploaded file

reqFTP.ContentLength = fileInf.Length;

// The buffer size is set to 2kb

int buffLength = 2048;

byte[] buff = new byte[buffLength];

int contentLen;

// Opens a file stream (System.IO.FileStream) to read the file to be uploaded

FileStream fs = fileInf.OpenRead();

try

{

// Stream to which the file to be upload is written

Stream strm = reqFTP.GetRequestStream();

// Read from the file stream 2kb at a time

contentLen = fs.Read(buff, 0, buffLength);

// Till Stream content ends

while (contentLen != 0)

{

// Write Content from the file stream to the FTP Upload Stream

strm.Write(buff, 0, contentLen);

contentLen = fs.Read(buff, 0, buffLength);

}

// Close the file stream and the Request Stream

strm.Close();

fs.Close();

}

catch (Exception ex)

{

string ErrMsg = ex.Message;

}

Asp.Net Programming

Tuesday, 12 March 2013

Delete Particular or Selected Row from Datatable in Asp.net

Monday, 11 March 2013

How to select/deselect checkboxes in gridview

How to Check or UnCheck Checkboxes in Asp:gridview

Friday, 8 March 2013

How to upload/download file from FTP Server in Asp.net

About Me