use the code below..

System.Xml.Serialization.XmlRootAttribute xRoot = new System.Xml.Serialization.XmlRootAttribute();
xRoot.ElementName = "EnvironmentConfigurations";
xRoot.IsNullable = true;
System.Xml.Serialization.XmlSerializer ser = new System.Xml.Serialization.XmlSerializer(typeof(<your Type>), xRoot);
<your type> x = (<your Type>)ser.Deserialize(new System.IO.StringReader());

use the bellow code..

if (window.event) // eg. IE
{
keyASCII = window.event.keyCode;

    }
    else if (event.which) // eg. Firefox
    {
        keyASCII = event.which;
    }

If you don;t want to use Session object then declare a Static hash table and put all the Connection string when you get it and retrieve it through out the page

You must have to write a custom control to do that...

use ...

Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}

I think , The below code will help you much

Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}

Try this i think it will help you; Response.ContentType = "text/xml"; Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml"); Response.TransmitFile(Server.MapPath("~/images/sailbig.jpg")); SqlDataAdapter da = null; try { con = new SqlConnection(); con.ConnectionString = ConfigurationSettings.AppSettings["DSN"]; da = new SqlDataAdapter("select * from card_details", con); DataSet ds = new DataSet(); da.Fill(ds, "card_details"); ds.WriteXml(Response.OutputStream); Response.End(); } catch (SqlException ex) { throw new System.Exception("Error -- " + ex.Message); } catch (Exception exp) { throw new System.Exception("Error -- " + exp.Message); } finally { con.Close(); da.Dispose(); } }

This will help you much , I think it works fine :-D

Response.ContentType = "text/xml";
Response.AppendHeader("Content-Disposition", "attachment; filename=mmm.xml");
Response.TransmitFile(Server.MapPath("~/images/mmm.jpg"));
SqlDataAdapter da = null;
try
{
con = new SqlConnection();
con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
da = new SqlDataAdapter("select * from card_details", con);
DataSet ds = new DataSet(); da.Fill(ds, "card_details");
ds.WriteXml(Response.OutputStream);
Response.End();
}
catch (SqlException ex)
{
throw new System.Exception("Error -- " + ex.Message);
}
catch (Exception exp)
{
throw new System.Exception("Error -- " + exp.Message);
}
finally
{
con.Close(); da.Dispose();
}

modified on Thursday, February 4, 2010 6:01 AM

I think you are not use win form application . Is that true if it is then you can't do it using previous procedure.Please use a Custom pop up to do this.

try this

if (saveFileDialog.ShowDialog() == DialogResult.OK)

I wrote my code in VS 2008. Under dialog section of toolbox you can get the specified control. TRY this Code

System.Windows.Forms.SaveFileDialog saveFileDialog = new System.Windows.Forms.SaveFileDialog();

saveFileDialog.Filter = "XML Files (*.xml)|*.*";

if (saveFileDialog.ShowDialog(this) == DialogResult.OK)

{

string FileName = saveFileDialog.FileName;

if (FileName.Trim() != "")

{

// your Code here
}

}

use below code

private void button1_Click(object sender, EventArgs e)
{
saveFileDialog1.FileOk += new CancelEventHandler(saveFileDialog1_FileOk);
saveFileDialog1.ShowDialog(this);

    }

    void saveFileDialog1\_FileOk(object sender, CancelEventArgs e)
    {
        SaveFileDialog ss = sender as SaveFileDialog;

        SqlDataAdapter da = null;
        try
        {
            con = new SqlConnection();
            con.ConnectionString = ConfigurationSettings.AppSettings\["DSN"\];
            da = new SqlDataAdapter("select \* from card\_details", con);
            DataSet ds = new DataSet(); da.Fill(ds, "card\_details");
            ds.WriteXml(ss.FileName);
        }
        catch (SqlException ex)
        {
            throw new System.Exception("Error -- " + ex.Message);
        }
        catch (Exception exp)
        {
            throw new System.Exception("Error -- " + exp.Message);
        }
        finally
        {
            con.Close(); da.Dispose();
        }
        
    }

saveFileDialog1 is SaveFileDialog type win control.

Cool!Enjoy! :-D

I think you should put "SET NOCOUNT ON" in Top of your SP and "SET NOCOUNT OFF" At the end of your SP THANKS

For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command. For all other types of statements, the return value is -1. If a rollback occurs, the return value is also -1.

cache your previuos data and when you come back retrieve your data from cache... Thanks

You can cache your all search page details into a cache and repopulate the search page when you come back from cache... Thanks

Use window.parent.ParentPageJavascriptMethod(); Write ParentPageJavascriptMethod() in your parent page to update tpur parent page content. Thanks

Put this below attribute in the top of your Page Code behind and Name Parameter is the permitted user for this page.... [PrincipalPermission(SecurityAction.Demand,Name=@"kovairindia\palash",Unrestricted=false)] Thanks

You can use the below code if you using LINQ to Objects

private void button1_Click(object sender, EventArgs e)
{
List<Customer> customers = new List<Customer>();
customers.Add(new Customer { CustomerID = "A12I", CustomerName = "Palash" });
customers.Add(new Customer { CustomerID = "B20G", CustomerName = "Ankesh" });
customers.Add(new Customer { CustomerID = "A100I", CustomerName = "Subhadip" });
customers.Add(new Customer { CustomerID = "C12G", CustomerName = "Namita" });
var result = (from c in customers
where c.CustomerID.StartsWith("A") && c.CustomerID.EndsWith("I")
select c).ToList();
foreach (Customer c in result)
{
MessageBox.Show(c.CustomerName);
}
}

}

public class Customer
{
    public string CustomerID;
    public string CustomerName;
}

for Search A%I . In case Of Search %I% you can use String Contains method to do that In Case of LINQ to SQL You can Use the Syntax like

var result = (from c in db.Customers
where System.Data.Linq.SqlClient.SqlMethods.Like(c.CustomerID, "A%I")
select c).ToList();