Click here to Skip to main content
15,878,959 members

priyamsc - Professional Profile



Summary

    Blog RSS
20
Authority
-36
Debator
9
Enquirer
8
Organiser
167
Participant
0
Author
0
Editor
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Reputation

Weekly Data. Recent events may not appear immediately. For information on Reputation please see the FAQ.

Privileges

Members need to achieve at least one of the given member levels in the given reputation categories in order to perform a given action. For example, to store personal files in your account area you will need to achieve Platinum level in either the Author or Authority category. The "If Owner" column means that owners of an item automatically have the privilege. The member types column lists member types who gain the privilege regardless of their reputation level.

ActionAuthorAuthorityDebatorEditorEnquirerOrganiserParticipantIf OwnerMember Types
Have no restrictions on voting frequencysilversilversilversilver
Bypass spam checks when posting contentsilversilversilversilversilversilvergoldSubEditor, Mentor, Protector, Editor
Store personal files in your account areaplatinumplatinumSubEditor, Editor
Have live hyperlinks in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Have the ability to include a biography in your profilebronzebronzebronzebronzebronzebronzesilverSubEditor, Protector, Editor
Edit a Question in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Edit an Answer in Q&AsilversilversilversilverYesSubEditor, Protector, Editor
Delete a Question in Q&AYesSubEditor, Protector, Editor
Delete an Answer in Q&AYesSubEditor, Protector, Editor
Report an ArticlesilversilversilversilverSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending ArticlegoldgoldgoldgoldSubEditor, Mentor, Protector, Editor
Edit other members' articlesSubEditor, Protector, Editor
Create an article without requiring moderationplatinumSubEditor, Mentor, Protector, Editor
Approve/Disapprove a pending QuestionProtector
Approve/Disapprove a pending AnswerProtector
Report a forum messagesilversilverbronzeProtector, Editor
Approve/Disapprove a pending Forum MessageProtector
Have the ability to send direct emails to members in the forumsProtector
Create a new tagsilversilversilversilver
Modify a tagsilversilversilversilver

Actions with a green tick can be performed by this member.


 
Questionhow to include 2 link button in datagrid and want to access both link . Pin
priyamsc11-Mar-08 18:17
priyamsc11-Mar-08 18:17 
how to include 2 link button in datagrid and i wud like to add codings for both link button i have writtencoding for one link button but in second link button i m not able to access and for what purpose we are givin datagrid1.editindexitem=-1

if u have answer pls help me

the code is
===========
protected void DataGrid1_ItemCommand(object source, DataGridCommandEventArgs e)
{
if (e.CommandName == "lnkbt1")
{
int k = Convert.ToInt32(e.CommandArgument.ToString());
DataGrid1.EditItemIndex = -1;
con = new SqlConnection("server=SOFTWARE4;uid=sa;pwd=;database=helpdesk1");
con.Open();
string m = "select callno,blkid,locid,deptid,pblmtype,problem,allocated,allocatedby from swiftresult where callno="+k;
cmd = new SqlCommand(m, con);
loaddata();
dr = cmd.ExecuteReader();
if (dr.Read())
{
string d=DateTime.Now.ToString();
string block = (string)dr["blkid"].ToString();
string loc = (string)dr["locid"].ToString();
string dep = (string)dr["deptid"].ToString();
string pbtype = (string)dr["pblmtype"].ToString();
string problem = (string)dr["problem"].ToString();
string allocatedby = (string)dr["allocatedby"].ToString();
SqlConnection con1 = new SqlConnection("server=SOFTWARE4;uid=sa;pwd=;database=helpdesk1");
con1.Open();
string upd="update swiftresult set status='c' where allocated='"+txt_uname.Text+"' and callno="+k;
string query="insert into ituser_status(callno,blkid,locid,deptid,pblmtype,problem,completedon,completedby,allocatedby)values("+k+",'"+block+"','"+loc+"','"+dep+"','"+pbtype+"','"+problem+"','"+d+"','"+txt_uname.Text+"','"+allocatedby+"')";
SqlCommand cmd1 = new SqlCommand(query, con1);
SqlCommand cmd2 = new SqlCommand(upd, con1);
cmd1.ExecuteNonQuery();
cmd2.ExecuteNonQuery();
Response.Write(k);
loaddata();
con1.Close();
}
if (e.CommandName == "lnkbt2")
{
int x = Convert.ToInt32(e.CommandArgument.ToString());
DataGrid1.EditItemIndex = -1;
con = new SqlConnection("server=SOFTWARE4;uid=sa;pwd=;database=helpdesk1");
con.Open();
string l = "select callno,blkid,locid,deptid,pblmtype,problem,allocated,allocatedby from swiftresult where callno=" + x;
cmd = new SqlCommand(l, con);
loaddata();
dr = cmd.ExecuteReader();
if (dr.Read())
{
string upd1 = "update swiftresult set status='e' where allocated='" + txt_uname.Text + "' and callno=" + x;
SqlCommand cmd1 = new SqlCommand(upd1, con);
cmd1.ExecuteNonQuery();
Response.Write("loaded");
loaddata();
//con.Close();
}
}
dr.Close();
con.Close();
}
}

k.priya

AnswerRe: how to include 2 link button in datagrid and want to access both link . Pin
Venkatesh Mookkan9-Aug-09 16:35
Venkatesh Mookkan9-Aug-09 16:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.