please , help me ...here is my code...
runat="server"
Text="Team name :">
runat="server">
runat="server"
ControlToValidate="tbxTeamName"
Display="Dynamic"
ErrorMessage="*"
ValidationExpression="^[A-Z][a-z]{2,10}$"
ValidationGroup="NameValidation" />
runat="server"
ControlToValidate="tbxTeamName"
Display="Dynamic"
ErrorMessage="Please,enter a team name!" />
runat="server"
Text="Team email :">
runat="server">
runat="server"
ControlToValidate="tbxTeamEmail"
Display="Dynamic"
ErrorMessage="*"
ValidationExpression="^[^_,=,+,@,!,$,%,*,(,),-,<,>,\d]\w*@\w{2,}[^\d].\w{1,}[^\d]$"
ValidationGroup="EmailValidation" />
runat="server"
ControlToValidate="tbxTeamEmail"
Display="Dynamic"
ErrorMessage="Please,enter a team email!" />
runat="server"
Text="Add"
OnClick="BtnAdd_Click" />
GridLines="None" Width="496px" AutoGenerateColumns="false">
team.asp.cs ....
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Futsal.DataAccess;
namespace Futsal.Admin
{
public partial class Teams : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
Bind();
}
public void Bind()
{
try
{
CTeam cTeam = new CTeam();
GridViewTeams.DataSource = cTeam.GetAllTeams();
GridViewTeams.DataBind();
}
catch (Exception err)
{
Response.Write(err.Message);
}
}
protected void BtnAdd_Click(object sender, EventArgs e)
{
CTeam cteam = new CTeam();
cteam.AddTeams(tbxTeamName.Text,tbxTeamEmail.Text);
}
}
}
Cteam.cs ...
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Futsal.BusinessLogic;
using System.Data.Linq;
using System.Data;
namespace Futsal.DataAccess
{
public class CTeam
{
#region Properties
#endregion
#region Constructor
#endregion
#region Method
public bool AddTeams(string _name, string _email)
{
try
{
using (var db = new BusinessLogic.FutsalDataContext())
{
Team team = new Team();
team.team_name = _name;
team.team_email = _email;
db.Teams.InsertOnSubmit(team);
db.SubmitChanges();
}
return true;
}
catch
{
return false;
}
}
public DataTable GetAllTeams()
{
try
{
DataTable dt = new DataTable();
dt.Columns.Add("teamID", typeof(short));
dt.Columns.Add("team_name", typeof(string));
dt.Columns.Add("team_email", typeof(string));
using (var db = new FutsalDataContext())
{
var data = db.Teams;
foreach (Team team in data)
{
DataRow dr = dt.NewRow();
dr["teamID"] = team.teamID;
dr["team_name"] = team.team_name;
dr["team_email"] = team.team_email;
dt.Rows.Add(dr);
}
return dt;
}
}
catch
{
return null;
}
}
#endregion
}
}
3 Replies
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Iftikar HussainPosted Aug 11, 2013, 10:27 AM
Regards,
Iftikar
Elshen ZamanovPosted Aug 11, 2013, 5:29 AM
Iftikar HussainPosted Aug 11, 2013, 3:29 AM
Please refer the link
http://www.aspdotnet-suresh.com/2011/02/how-to-inserteditupdate-and-delete-data.html
Regards,
Iftikar