3
Answers

Java script and .Net

sHREYAS jOSHI

sHREYAS jOSHI

14y
2.1k
1
Actually i want to use Slandered validation control like required field validation in JavaScript shall i use it ?
Answers (3)
0
Amit Choudhary

Amit Choudhary

NA 27.7k 3m 14y
hi friend,

I have not concern the Comments. and you have to change the connection string i have used a demo connection string.

Here is your code for c#:

 SqlDataReader rdr1, rdr2;
              String localityid,villageid;
            try{
                SqlConnection cn=new SqlConnection(@"Data Source=.\SqlExpress;Initial Catalog=Demodb;Integrated Security=True;Pooling=False");
                SqlCommand cmd=new SqlCommand();
                string familyid=Request.QueryString["familyid"];
                cmd.CommandText="select * from HOUSEHOLDMEMBERS where FamilyId='"+familyid+"'";
                rdr1=cmd.ExecuteReader();
                 String tempMemberid="";
                 String tempNum="";
                while(rdr1.Read())
                {
                      tempMemberid=rdr1["MemberId"].ToString();
                }
                 int count1 = tempMemberid.Length;
                String memnum = tempMemberid.Substring(count1-2);
               
                int memno;
               if(int.TryParse(memnum,out memno))
                    memno++;
                String seqNo = memno.ToString();
                 if(memno < 10) {
                    tempMemberid = familyid + "0" + seqNo;
                }
                 else{
                    tempMemberid = familyid + seqNo;
                }


Please mark as answer if it helps