10
Answers

How to insert only five values a an ID in SQL and C#

i want to add only five subject marks for each student...how i will restrict an Stduent_ID ?if Stduent_ID=1 and inserted five times then for six entry i should not add...how i will do it in C# + SQL.
Answers (10)
0
Santhosh Kumar Jayaraman
NA 9.9k 2.3m 12y
0
Richa Garg
NA 11k 2.9m 12y
Hi santhosh,
   No I am not saying this, actually I saw an example from http://www.typescriptlang.org/Samples/ site. In this see the sample of TodoMVC, and then tell me Is this possible In asp.net. If yes then how?
0
Satyapriya Nayak
NA 53k 8m 12y
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication3._Default" %>

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

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
   
        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox><br />
        <asp:DropDownList ID="DropDownList1" runat="server">
        </asp:DropDownList><br />
    <asp:Button ID="Button1" runat="server" Text="Button" onclick="Button1_Click" />
    </div>
   
    </form>
</body>
</html>



using System;
using System.Collections;
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;

namespace WebApplication3
{
    public partial class _Default : System.Web.UI.Page
    {
       
        protected void Button1_Click(object sender, EventArgs e)
        {
           DropDownList1.Items.Add(TextBox1.Text);
           DropDownList1.Visible = true;
           TextBox1.Visible = false;
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            DropDownList1.Visible = false;
        }
    }
}

0
Santhosh Kumar Jayaraman
NA 9.9k 2.3m 12y
You meant to say you have 2 controls? one is textbox and another is dropdown and watever text i enter and pres enter, this text should be included in the items in drodownlist?