Remove empty rows from Dataset

try this.. Smile | :)

DataSet ds = new DataSet();

 
                for (int i = 0; i < ds.Tables.Count; i++)
                { 
                      for (int j = 0; j < ds.Tables[i].Rows.Count; j++)
                    {
                        if (Convert.ToString(ds.Tables[i].Rows[j]["ColumnName"]) == string.Empty)
                        {
                            ds.Tables[i].Rows[j].Delete();
                        
                        }
                    }
                
                }

i have created this snippet without testing of it, so modify it according to your need.

Insert , Update, Delete list of items in cookies.

add values to cookies in C#

HttpCookie cookie = new HttpCookie("mybigcookie");

cookie.Values.Add("name", name);

cookie.Values.Add("address", address);

delete cookies item in C#

Response.Cookies["CoockieName"].Values["itemIndex"] = String.Empty;

How Can I Split A String In Vb.Net

  Dim FileName As String = Path.GetFileName("~/photos/consultant/images.jpeg")

How to use insertion and deletion of row using stored procedure.

try operational stored procedure.
You have to declare variable @operation with int datatype like as shown below,
Now you can execute perticular query with just passing @operation from backend.

You can put both query in one operation as you wish.
You can execute multiple operations with this query.... Smile | :)

CREATE PROCEDURE SP_MyQuery

@ItemCode VARCHAR(50)=''

,@ItemDescription VARCHAR(250)=''

,@ItemCategoryID INT=0

,@ItemID INT=0

,@operation int=0

BEGIN

IF(@operation=1)

begin

--What ever you want to execute, insert query , update query , delete query, select query

end

ELSE IF(@operation-2)

BEGIN

--What ever you want to execute, insert query , update query , delete query, select query

END

Send Sms from ASP.NET using Full On Sms

1) HTML

<%@ Page Language="C#" AutoEventWireup="true"  CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<asp:Label ID="Label1" runat="server" Text="Mobile No"></asp:Label> <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

<br />

<asp:Label ID="Label2" runat="server" Text="Message"></asp:Label>

<asp:TextBox ID="TextBox2" runat="server" TextMode="MultiLine"></asp:TextBox>

<br />

<asp:Button ID="Button1" runat="server" Text="Send Sms"

onclick="Button1_Click" />

</div>

</form>

</body>

</html>

2) C#

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Net;

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

{

string uid;

string password;

string message;

string no;

protected void Page_Load(object sender, EventArgs e)

{

}

//This is the code of API for sending message.

public void send()

{

HttpWebRequest myReq = (HttpWebRequest)WebRequest.Create("http://ubaid.tk/sms/sms.aspx?uid=" + uid + "&pwd=" + password + "&msg=" + message + "&phone=" + no + "&provider=fullonsms");

HttpWebResponse myResp = (HttpWebResponse)myReq.GetResponse();

System.IO.StreamReader respStreamReader = new System.IO.StreamReader(myResp.GetResponseStream());

string responseString = respStreamReader.ReadToEnd();

respStreamReader.Close();

myResp.Close();

}

protected void Button1_Click(object sender, EventArgs e)

{

try

{

uid = "";

password = "";

message = TextBox2.Text;

no = TextBox1.Text;

send();

TextBox2.Text = "";

TextBox1.Text = "";

}

catch (Exception ex)

{

ex.Message.ToString();

}