Comments by Kanaparthi Sureshma Reddy

Kanaparthi Sureshma Reddy 3-Sep-15 1:28am View

Sorry,It's not Page it is a Form.

Kanaparthi Sureshma Reddy 27-Aug-15 2:07am View

This is my code in btnNext_Click event.
int nextCount = minValue + maxValue;
dt = new DataTable();
da.Fill(nextCount, maxValue, dt);
GridAddressBook.DataSource = dt;
lblShowResults.Text = GridAddressBook.RowCount.ToString();
int windowshow = int.Parse(lblShowResults.Text);
if (windowshow <= 5)
{

int nextpage = Convert.ToInt32(lblWindowShow.Text) + 1;
lblWindowShow.Text = Convert.ToString(nextpage);
//lblWindowShow.Text = "2";
}
else if (windowshow <= 5)
{
lblWindowShow.Text = (objD.NoOfRecords() / 10).ToString();
}
lblShowingShow.Text = lblWindowShow.Text + "-" + lblShowResults.Text;
minValue = nextCount;
if (dt.Rows.Count == maxValue)
{
btnPrev.Enabled = true;
btnNext.Enabled = true;
}
else
{
btnPrev.Enabled = true;
btnNext.Enabled = false;
minValue = nextCount + dt.Rows.Count;
}
btnPrev.Enabled = true;
where lblShowResults=RecordCount in DataGrid,lblWindowShow=Window/Page Number and lblShowingShow=Showing results from 1-5,6-10...

Kanaparthi Sureshma Reddy 8-Jul-15 7:47am View

My requirement is When the student DOJ is current date(08-07-2015),then the current date should be changed to that particular date after one year by increasing the year(08-07-2016).
That means the student entered into Second Year based on incremented year..

Kanaparthi Sureshma Reddy 8-Jul-15 7:38am View

Is there any alternative other than this solution..??

Kanaparthi Sureshma Reddy 8-Jul-15 5:17am View

Can you please write including with the insert Stored procedure...Here Id is the primary key

Kanaparthi Sureshma Reddy 8-Jul-15 5:08am View

It's not Working..

Kanaparthi Sureshma Reddy 8-Jul-15 4:54am View

Actually the column has the data(20) but If I try to change that data(20 to 25) it won't allow me to enter new data(25)..
For that how to restrict to enter new data(the marks always should be what I insert first time only ie., 20 only)..

Kanaparthi Sureshma Reddy 15-Jun-15 1:21am View

While writing DBHelper, I am getting the below error "The name DBHelper doesn't exist in the current context".
How to solve this error?

Kanaparthi Sureshma Reddy 11-Jun-15 4:29am View

How to update Record in the grid view using checkbox?

Kanaparthi Sureshma Reddy 28-May-15 3:30am View

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
String sid = GridView1.DataKeys[e.RowIndex].Value.ToString();
String sname = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
String ac = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3")).Text;
String dc = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4")).Text;
String ss = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox5")).Text;
String oc = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox6")).Text;
String cn = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox7")).Text;
String co = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox8")).Text;
con.Open();
string q = "update student_sub set ac='" + ac + "',dc='" + dc + "',ss='" + ss + "',oc='" + oc + "',cn='" + cn + "',co='" + co + "' where stud_id='" + sid + "' ";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
Bind_Grid();
}

Kanaparthi Sureshma Reddy 28-May-15 2:42am View

Deleted

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
String sid = GridView1.DataKeys[e.RowIndex].Value.ToString();
String sname = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox2")).Text;
String ac = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox3")).Text;
String dc = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox4")).Text;
String ss = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox5")).Text;
String oc = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox6")).Text;
String cn = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox7")).Text;
String co = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("TextBox8")).Text;
con.Open();
string q = "update student_sub set ac='" + ac + "',dc='" + dc + "',ss='" + ss + "',oc='" + oc + "',cn='" + cn + "',co='" + co + "' where stud_id='" + sid + "' ";
SqlCommand cmd = new SqlCommand(q, con);
cmd.ExecuteNonQuery();
con.Close();
GridView1.EditIndex = -1;
Bind_Grid();
}

Kanaparthi Sureshma Reddy 27-May-15 23:58pm View

I have 8 columns and I want to hide all columns except specific column which is I chose from Dropdown list.

Kanaparthi Sureshma Reddy 27-May-15 8:23am View

Deleted

If I have 50 columns, I have to write visible property 50 times. For that tell me the alternate solution(I don't know but I thought that using for loop)

Kanaparthi Sureshma Reddy 22-May-15 6:04am View

Can you please tell me the Stored procedure to alter a column from frontend?

Kanaparthi Sureshma Reddy 22-May-15 5:43am View

Actually in my database I have a table with columns sub1,sub2,sub3.
Now I want to add a new column(sub4) from front end, When I click insert button in frontend that sub4 will be added to table like sub1,sub2,sub3,sub4.
What is the stored procedure and c# code for this?

Kanaparthi Sureshma Reddy 22-May-15 5:38am View

I am using 3-Tier Architecture

Kanaparthi Sureshma Reddy 22-May-15 5:37am View

Deleted

I am using 3-Tier Architecture..

Comments by Kanaparthi Sureshma Reddy (Top 17 by date)