Tuesday, September 28, 2010

create xml dynamically

public partial class User_userHome : System.Web.UI.Page
{
    SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings.Get("connString"));
    SqlCommand cmd;
    SqlDataReader dr,drdr;
    DBUpdate userNews = new DBUpdate();
   
    protected void Page_Load(object sender, EventArgs e)
    {
        string name = "";
              
        int idUser = Convert.ToInt32(Session["idUser"]);

        userNews.cmd.Parameters.Clear();

        SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        p.Direction = ParameterDirection.ReturnValue;
        userNews.cmd.Parameters.Add(p);
        userNews.cmd.Parameters.AddWithValue("@userid", idUser);

        string fetchrow = "select * from userRegistration,tblUser where userRegistration.userId = tblUser.registrationid and  tblUser.userid = " + idUser;

        drdr = userNews.datareader(fetchrow);
        while (userNews.dr.Read())
        {

            name = drdr["firstname"].ToString();
        }
        lblWelcome.Text = "Welcome " + name;
     
    }



    protected void dnldBtn_Click(object sender, ImageClickEventArgs e)
    {

        XmlTextReader reader = null;

        try
        {

            reader = new XmlTextReader("D:\\Lis\\RssNews\\User\\RssXml.xml");

            DataSet ds = new DataSet();

            ds.ReadXml(reader);
            //GridView1.DataSource = ds.Tables["item"];
            //GridView1.DataBind();

            Response.ContentType = "application/octet-stream";
            Response.ContentType = "application/x-download";
            Response.AddHeader("Content-Disposition", "attachment;filename=" + "RssXml.xml");


            Response.WriteFile(Server.MapPath("RssXml.xml"));
            Response.End();


        }

        catch (Exception ex)
        {

            lblMessage.Text = ex.Message;

        }

        finally
        {

            reader.Close();

        }

    }
    protected void btnRss_Click(object sender, ImageClickEventArgs e)
    {
        String strFilePath = "D:\\Lis2008\\RssFeeds\\User\\RssXml.xml";


        XmlTextWriter writer = new XmlTextWriter(strFilePath, Encoding.UTF8);
        writer.WriteStartDocument();
        writer.WriteStartElement("rss");
        writer.WriteAttributeString("version", "2.0");
        writer.WriteString("\n\n");
        writer.WriteStartElement("channel");
        writer.WriteString("\n\n");
        userNews.getcon();
        cmd = new SqlCommand("select * from tblNews", con);
        cmd.Connection = userNews.con;
        dr = cmd.ExecuteReader();
        int cnt = 1;
        while (dr.Read())
        {
            if (cnt == 1)
            {
                writer.WriteString("\n");
                writer.WriteElementString("title", dr["Title"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("description", dr["description"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("link", dr["link"].ToString());
                writer.WriteString("\n");

            }
            else
            {
                writer.WriteStartElement("item");
                writer.WriteString("\n");
                writer.WriteElementString("title", dr["title"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("description", dr["description"].ToString());
                writer.WriteString("\n");
                writer.WriteElementString("link", dr["link"].ToString());
                writer.WriteString("\n");
                writer.WriteEndElement();
                writer.WriteString("\n");
            }
            cnt = cnt + 1;
        }


        con.Close();


        writer.WriteEndElement();
        writer.WriteEndElement();
        writer.Flush();

        writer.Close();
        Response.Redirect("RssXml.xml");
    }


    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        //     string gender;

        //    string firstname = txtFirstName.Text.ToString();
        //    string lastname = txtLastName.Text.ToString();
        //    string username = txtUsername.Text.ToString();
        //    string password = txtPassword.Text.ToString();
        //    string address = txtAddress.Text.ToString();
        //    string mobile = txtMobile.Text.ToString();
        //    string phone = txtPhone.Text.ToString();
        //    string email = txtEmail.Text.ToString();

        //    if (rdmale.Checked)
        //    {
        //        gender = "M";
        //    }
        //    else gender = "F";
        //     string status = "Active";
        //     userNews.cmd.Parameters.Clear();

        //     SqlParameter p = new SqlParameter("@ret", SqlDbType.Int);
        //     p.Direction = ParameterDirection.ReturnValue;
        //     userNews.cmd.Parameters.Add(p);
        //     userNews.cmd.Parameters.AddWithValue("@firstname", txtFirstName.Text);
        //     userNews.cmd.Parameters.AddWithValue("@lastname", txtLastName.Text);
        //     userNews.cmd.Parameters.AddWithValue("@username", txtUsername.Text);
        //     userNews.cmd.Parameters.AddWithValue("@password", txtPassword.Text);
        //     userNews.cmd.Parameters.AddWithValue("@address", txtAddress.Text);
        //     userNews.cmd.Parameters.AddWithValue("@mobile", txtMobile.Text);
        //     userNews.cmd.Parameters.AddWithValue("@phone", txtPhone.Text);
        //     userNews.cmd.Parameters.AddWithValue("@email", txtEmail.Text);
        //     userNews.cmd.Parameters.AddWithValue("@gender", gender);
        //     userNews.cmd.Parameters.AddWithValue("@status", status);

        //    ccJoin.ValidateCaptcha(txtCaptcha1.Text);
        //      if (ccJoin.UserValidated)
        //     {
        //         string s = userNews.excproc("userinsert");
        //         clientScriptAlert("Registered Successfully");
        //     }
        //     else
        //         return;
        //}
        //private void clientScriptAlert(string Message)
        //{
        //    Page.RegisterClientScriptBlock("clientScript", "<script>alert('" + Message + "')</script>");
        }

    }


   

No comments:

Post a Comment