Send temporary linked item data to database

Question

0.00/5 (No votes)

See more:

Hi.
I have a code here,where it will store temporary data in a gridview from textbox where when the data is stored temporarily in gridview,it will be linked to search the word in google.
Now i want to send the linked values to database.
Any ideas guys?
My aspx code:

XML

<body>
    <div>
    <table >
    <tr>
    <td class="style1">
    <asp:Label ID="Label1" runat="server" Text="Caller Info :"></asp:Label>
    </td>
    <td style="width: 100px">
    <asp:TextBox ID="TxtName" runat="server" class="cls" onekeypress=""  ToolTip="Press Enter key for new input"></asp:TextBox>
    </td>
    </tr>
    </table>

    <asp:Button ID="BtnAddToTable" runat="server" align="right" class="cls"
    Text="Add" OnClick="BtnAddToTable_Click" />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" >
    <Columns>
    <asp:TemplateField HeaderText="Caller Information">
    <ItemTemplate>
    <a onclick='document.getElementById("<%=iframe1.ClientID%>").src = this.href; return false;' href='http://www.google.com/#q=<%#DataBinder.Eval(Container.DataItem,"name")%>'>
    <%#DataBinder.Eval(Container.DataItem,"name")%></a>
    </ItemTemplate>
    </asp:TemplateField>
    <asp:TemplateField HeaderText="">
    <ItemTemplate>
    <asp:Button ID="BtnDelete" runat="server" Text="Clear" OnClick="BtnDelete_Click" />
    </ItemTemplate>
    </asp:TemplateField>
    </Columns>
    </asp:GridView>
    <iframe runat="server" id="iframe1" src="" class="cls"
     style="z-index: 105; left: 225px; position: absolute; top: 109px; width: 875px; height: 455px;" frameborder="1" title="Google Search Display" ></iframe>
</div>
        <asp:Button ID="BtnSendToDatabase" runat="server" class="cls" Text="//Sent to database" OnClick="BtnSendToDatabase_Click" />
</body>

My cs code:

static DataTable dt;
        protected void Page_Load(object sender, EventArgs e)
        {
            {
                if (!Page.IsPostBack)
                {
                    //Instantiating the DataTable;
                    dt = new DataTable("Table1");

                    //Adding Columns
                    dt.Columns.Add("name", typeof(string));

                }
            }
        }
        protected void BtnAddToTable_Click(object sender, EventArgs e)
        {
            dt.Rows.Add(TxtName.Text);
            BindData();
            TxtName.Text = String.Empty;
            
        }

        public void BindData()
        {
            GridView1.DataSource = dt;
            GridView1.DataBind();
        }

        protected void BtnDelete_Click(object sender, EventArgs e)
        {
            string sid = string.Empty;
            string sname = string.Empty;
            Button cb = sender as Button;
            GridViewRow grow = (GridViewRow)cb.NamingContainer;
            dt.Rows.RemoveAt(grow.RowIndex);
            BindData();
        }

Posted 7-Sep-10 17:18pm

pwtc222

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fayu · Answer 1 · 2010-09-08T10:23:00

Solution 1

If you are trying to get the values of the inputs from the datatable, you can do this:

C#

foreach (DataRow row in dt.Rows)
{
    Console.WriteLine(row["name"].ToString());
}

Posted 8-Sep-10 10:23am

Fayu

Comments

Dalek Dave 8-Sep-10 16:43pm

Good Call.

pwtc222 8-Sep-10 21:04pm

Hi.
How may i send the values in the datatable into database?
I have a code here :
cmd.CommandText = "INSERT INTO Table1 (Company_Name) VALUES ('" + TxtName.Text + "')";

pwtc222 8-Sep-10 21:05pm

SqlConnection conn = new SqlConnection();
conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Table1 (Company_Name) VALUES ('" + TxtName.Text + "')";
cmd.Connection = conn;

conn.Open();
cmd.ExecuteNonQuery();
conn.Close();

pwtc222 9-Sep-10 2:46am

where do i apply this code?

Fayu · Answer 2 · 2010-09-09T03:13:00

First of all, NEVER build a command like this:

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Table1 (Company_Name) VALUES ('" + TxtName.Text + "')";

Doing this exposes you to sql injection vulnerabilities. Instead, do this:

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Table1 (Company_Name) VALUES (@compName)";
cmd.Parameters.AddWithValue("@compName", TxtName.Text);

In regards to where to add this code, that all depends on your code. Ideally, you want to seperate your data access, business logic and presentation layers (n-Tier architecture). There are many artciles on the web that explain this architecture. Below are some articles that can help you get started:

Link 1[^]
Link 2[^]

Since you seem like you are a beginner, for testing and learning purposes, you can do this, however, I do not recommend the below method:

SqlCommand cmd = new SqlCommand();
cmd.CommandText = "INSERT INTO Table1 (Company_Name) VALUES (@compName)";
foreach (DataRow row in dt.Rows)
{
     cmd.Parameter.AddWithValue("@compName", row["name"].ToString());
     cmd.ExecuteNonQuery();
}

After all your inserts are done, don't forget to clean up after yourself. Dispose of the objects you are done with (cmd, conn..)

cmd.Dispose();
conn.Close();
conn.Dispose();