java code to c#...

Question

i want the given java code in c#...cud anyone help me with this.....

ResultSet resultset, resultset1;
            String localityid,villageid;
            try{
            Connection connection= DriverManager.getConnection("jdbc:odbc:rmcwhDSN");
            Statement statement= connection.createStatement();
            String familyid = request.getParameter("familyid");
            String tempSQL = "select * from HOUSEHOLDMEMBERS where FamilyId='"+familyid+"'";
            //out.println(tempSQL);
            resultset=statement.executeQuery(tempSQL);
            String tempMemberid="";
            String tempNum="";
            while(resultset.next())
            {
            tempMemberid = resultset.getString("MemberId");
            }
            //out.println(tempMemberid);
            int count1 = tempMemberid.length();
           // out.println(count1);
            
            //if(countl >2 ) {
                String memnum = tempMemberid.substring(count1-2);
                int memno = (new Integer(memnum)).intValue();
                //out.println ("Last member sq. number " + memno);                           
                memno++;
                String seqNo = Integer.toString(memno);
               // out.println ("Last member sq. number " + seqNo);                           
                if(memno < 10) {
                    tempMemberid = familyid.concat("0").concat(seqNo);
                }else{
                    tempMemberid = familyid.concat(seqNo);
                }
           // }    
            //tempMemberid = familyid.concat(count2);

Answer 1

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