Re: how to pass link through gridview using linkbutton - C# Discussion Boards

Assigning value to Column in DatagridView

Osama12331-Oct-07 1:37

31-Oct-07 1:37

Hi All,

I have datagridview populated from a database thru a datasource.
I have an integer col status with values (1,2,3)
I want to Fill grid with values for status ex 1 is Active,2 is Inactive and 3 is default
How shud i do this.

I am using Visual Studio C# 2005 express edition.

Regards,
Ahmad

Re: Assigning value to Column in DatagridView

Frank Kerrigan31-Oct-07 3:42

Frank Kerrigan

31-Oct-07 3:42

use the itemdatabound to change the value.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

How to use ExecuteReader() with Oracle DB?

babutkchn31-Oct-07 1:30

babutkchn

31-Oct-07 1:30

hi,

In my appication i'm using Oracle as a back end. In that when i'm using ExecuteReader() it shows an exception. Can any one of help me to solve this issue.

<br />
oleDBConnection = new OleDbConnection(connectString);                   <br />
                    string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = ?) AND (V_PASSWORD = ?)";<br />
<br />
                    OleDbCommand oledbCmd = new OleDbCommand(query, oleDBConnection);<br />
                    oledbCmd.CommandText = query;<br />
<br />
                    oledbCmd.CommandType = CommandType.Text;<br />
<br />
                    OleDbParameter par = oledbCmd.Parameters.Add("UserName", OleDbType.VarWChar, 50);<br />
                    OleDbParameter parm = oledbCmd.Parameters.Add("password", OleDbType.VarWChar, 50);<br />
<br />
                    oledbCmd.Parameters["UserName"].Value = userName;<br />
                    oledbCmd.Parameters["password"].Value = password;<br />
<br />
                    oledbCmd.Connection = oleDBConnection;<br />
<br />
                    oleDBConnection.Open();<br />
                    <br />
                    OleDbDataReader dr ;<br />
                    dr = oledbCmd.ExecuteReader();<br />

It threw an exception when executing the last line. The exception states that Unspecified error.Oracle error occured,but error message could not retrieved from Oracle.Data Type is not supported.

Thanks in advance

Babu

Re: How to use ExecuteReader() with Oracle DB?

Andrei Ungureanu31-Oct-07 2:15

Andrei Ungureanu

31-Oct-07 2:15

babutkchn wrote:
string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = ?) AND (V_PASSWORD = ?)";

You add parameters to the query, but you don't specify anywhere these parameters. Try this

 string query = "SELECT V_FIRST_NAME,V_LAST_NAME,V_PHONE_NUMBER,V_EMAIL,V_FAX_NUMBER,V_ADDRESS,V_TITLE,V_POSTAL_CODE,V_COUNTRY from UserDetails where (V_USER_ID = @UserName) AND (V_PASSWORD = @password)";

OleDbCommand oledbCmd = new OleDbCommand(query, oleDBConnection);
oledbCmd.CommandText = query;

oledbCmd.CommandType = CommandType.Text;

OleDbParameter par = oledbCmd.Parameters.Add("@UserName", OleDbType.VarWChar, 50);
OleDbParameter parm = oledbCmd.Parameters.Add("@password", OleDbType.VarWChar, 50);

Hope it helps.

There are 10 kinds of people: those who understand binary and those who don't

Re: How to use ExecuteReader() with Oracle DB?

babutkchn31-Oct-07 2:22

babutkchn

31-Oct-07 2:22

we are using oracle not sql server('@symbol is not supported in Oracle').
give me the solution

Re: How to use ExecuteReader() with Oracle DB?

Andrei Ungureanu31-Oct-07 3:51

Andrei Ungureanu

31-Oct-07 3:51

Ok, my bad. But still, you have to find a way to specify the parameters in the query. I think that that's your problem.

There are 10 kinds of people: those who understand binary and those who don't

how to pass link through gridview using linkbutton [modified]

alok217131-Oct-07 1:15

alok2171

31-Oct-07 1:15

how to pass link through gridview using linkbutton..i dont want to delete it.just pass a link.

alok2171

Re: how to pass link through gridview using linkbutton

soni uma31-Oct-07 1:28

soni uma

31-Oct-07 1:28

Here Code For the Delete Link In grid view

<asp:GridView DataKeyNames="CategoryID" ID="GridView1"
runat="server" AutoGenerateColumns="False"
OnRowCommand="GridView1_RowCommand"
OnRowDataBound="GridView1_RowDataBound"
OnRowDeleted="GridView1_RowDeleted" OnRowDeleting="GridView1_RowDeleting">
<Columns>
<asp:TemplateField HeaderText="Select">
<ItemTemplate>
<asp:LinkButton ID="LinkButton1"
CommandArgument='<%# Eval("CategoryID") %>'
CommandName="Delete" runat="server">
Delete</asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>

:-

Logical Drive Info

half-life31-Oct-07 0:29

half-life

31-Oct-07 0:29

HI,

i'm using VS 2005 Express.

i like to know how to get the Logical Drive Info, like :

Size, Used Size, Free Size

THNKS in Advance

Have Fun
Never forget it

Re: Logical Drive Info

Giorgi Dalakishvili31-Oct-07 0:32

Giorgi Dalakishvili

31-Oct-07 0:32

DriveInfo Class[^] is your friend Smile | :)

#region signature
my articles
#endregion

Re: Logical Drive Info

half-life31-Oct-07 0:35

half-life

31-Oct-07 0:35

THANKS

i did not saw it becaude i was missing th IO

THNKS Smile | :)

Have Fun
Never forget it

Re: Logical Drive Info

Giorgi Dalakishvili31-Oct-07 0:37

Giorgi Dalakishvili

31-Oct-07 0:37

Glad to help you Smile | :)

#region signature
my articles
#endregion

convert vc++6 program to dll or ocx to use in .net(c#)

small_programmer31-Oct-07 0:27

small_programmer

31-Oct-07 0:27

there is a wonderful artical about digit recognition at:
http://www.codeproject.com/library/NeuralNetRecognition.asp
in vc++6 language.
I want to use this wonderful program as a dll or ocx in c#.
can anyone help me?
has anyone done this work before?
and can anyone give me this dll or ocx?
(i'm not familiar with nor understand difficult vc++6 programs)
very thanks in advance.

Toolbar button from mouse position

Hans Ruck31-Oct-07 0:16

Hans Ruck

31-Oct-07 0:16

Hi,

I am writing a Windows Forms application.
Is there any method of finding the toolbar button currently under the mouse cursor? It seems that the button objects are not Control (class) derived...

"la dolce ossessione degli ultimi suoi giorni tristi,
Venezia, la vende ai turisti"

rechi

Re: Messaging

Christian Graus31-Oct-07 0:16

Christian Graus

31-Oct-07 0:16

OK - I've got it now. You're trolling. Congratulations, you had me fooled for a moment.

If this is a joke, get a life. If it's not, then I am at a loss.

Christian Graus - Microsoft MVP - C++

"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )

Re: Messaging

Anthony Mushrow31-Oct-07 0:41

Anthony Mushrow

31-Oct-07 0:41

Seems like i missed something Sniff | :^)

My current favourite word is: Waffle

Cheese is still good though.

Re: Ajax

Christian Graus31-Oct-07 0:10

Christian Graus

31-Oct-07 0:10

I told you this was rude and inappropriate and you decided that must mean you should post it to some other forums as well ?

DataGrid shown horizontally

haseeb_saeed31-Oct-07 0:07

haseeb_saeed

31-Oct-07 0:07

hello
i want to display a datagrid control horizontally, that is i want the rows to be columns and the columns to be rows... i need this with the datagrid coz i want users to give feedback in it... so there is no reason why i shud use a listview, by the way, can a list view be used to enter data...

The scenerio i have is
color1 red
color2 ---
color3 blue
and i want it as
color1 color2 color3
red --- blue

and the user is able to change color 2 to somethin else , if he desires...

Please help,
Thanx

haseeb

CreditXpert webservices using c#.net

PrakashBhaskar31-Oct-07 0:05

PrakashBhaskar

31-Oct-07 0:05

I can able to asign values most of the function except choice element in XSD

Thanks
Warm Regards
Prakash-B

Re: CreditXpert webservices using c#.net

Christian Graus31-Oct-07 0:12

Christian Graus

31-Oct-07 0:12

Odds are high that you're asking for help in using a webservice that most of us probably have not heard of. Otherwise, your question makes no sense at all. What do their docs say ? Do they have a support forum ?

Failed to map the path App_GlobalResources

Sun Rays31-Oct-07 0:03

Sun Rays

31-Oct-07 0:03

How to resolve this problem ?
I had gave permission to machinkey folder, but no help.
Eventhough I register framework with IIS again.

Thanks,
Sun Rays

Re: Failed to map the path App_GlobalResources

Malcolm Smart31-Oct-07 2:04

Malcolm Smart

31-Oct-07 2:04

YOu might be better off in the ASP.NET forum.

"More functions should disregard input values and just return 12. It would make life easier." - comment posted on WTF

"This time yesterday, I still had 24 hours to meet the deadline I've just missed today."

Grid view sort going infinite loop

Sobel Jose Alappat30-Oct-07 23:59

Sobel Jose Alappat

30-Oct-07 23:59

Hi
I have a gridview in an aspx page.
The paging is working. But the sorting doesnot..It goes into an infinite loop..

Could you tell me what is going wrong..

Do I need to bind the datagrid after the sort function is called....

I couldn't find a correct answer so far ..

So please let me know the exact problem with this code.

Thank you

The following is the code

<asp:GridView ID="dg" runat="server" AutoGenerateColumns="false" AllowSorting="true" AllowPaging="True" OnSorting="dg_Sorting" OnPageIndexChanging="dg_PageIndexChanging" Width="447px">
<columns>
<asp:boundfield datafield="jobid" HeaderText="JOBID" SortExpression="jobid" />
<asp:boundfield datafield="jobpost" headertext="JOB NAME" SortExpression="jobpost" />
<asp:boundfield datafield="description" headertext="DESCRIPTION" SortExpression="description" />
<asp:boundfield datafield="nocondition" headertext="NO: OF CONDITIONS" SortExpression="nocondition" />

</columns>

</asp:GridView>

And I have the code for onSorting=dg_Sorting as follows

public partial class jobdetails : System.Web.UI.Page
{
SqlCommandBuilder c;
SqlDataAdapter da1;
DataSet ds1;
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection ctr = new SqlConnection("data source =.\\SQLEXPRESS; initial Catalog=udus;user id=sa;password=pass123");
da1 = new SqlDataAdapter("select* from JOBMASTER", ctr);
ctr.Open();
c = new SqlCommandBuilder(da1);
ds1 = new DataSet();
da1.Fill(ds1, "JOBMASTER");
dg.DataSource = ds1;
dg.DataBind();

}

public void DataBind1()
{
SqlConnection ctr = new SqlConnection("data source =.\\SQLEXPRESS; initial Catalog=udus;user id=sa;password=pass123");
da1 = new SqlDataAdapter("select* from JOBMASTER", ctr);
ctr.Open();
c = new SqlCommandBuilder(da1);
ds1 = new DataSet();
da1.Fill(ds1, "JOBMASTER");
dg.DataSource = ds1;

}

public void dg_Sorting(object sender,GridViewSortEventArgs e)

{

string oldexpression = dg.SortExpression;
string newexpression = e.SortExpression;

if (oldexpression.IndexOf(newexpression) < 0)
{
if (oldexpression.Length > 0)
{
e.SortExpression = newexpression + "," + oldexpression;
}
else
{
e.SortExpression = newexpression;
}
}
else
{
e.SortExpression = oldexpression;
}

SortDirection direction;
direction = SortDirection.Ascending;
dg.Sort(e.SortExpression, direction);
}

protected void dg_PageIndexChanging(object source, GridViewPageEventArgs e)
{
DataBind1();
dg.PageIndex = e.NewPageIndex;
dg.DataBind();
}
}

Re: Grid view sort going infinite loop

Sun Rays31-Oct-07 0:16

Sun Rays

31-Oct-07 0:16

Hi,
U cant set sorting like this.
U have to rete one function in that U can use dataview.

public void fillData(string sortExp)
{
if (Session["dv"] != null)
{
dv = (DataView)Session["dv"];
}
else
{
DataSet ds = new DataSet();
/// GET DATASET VALUE FROM YOUR FUNCTION
dv = new DataView();
dv.Table = ds.Tables[0];
}
dv.Sort = sortExp;
//// BIND DATAVIEW TO GRIDVIEW
}

Call this function from GridView sorting event.

if (ViewState["sort"] != null)
{
if ((SortDirection)ViewState["sort"] == SortDirection.Ascending)
{
ViewState["sort"] = SortDirection.Descending;
fillData(e.SortExpression.ToString() + " asc");
}
else
{
ViewState["sort"] = SortDirection.Ascending;
fillData(e.SortExpression.ToString() + " desc");
}
}
else
{
if (e.SortDirection == SortDirection.Ascending)
{
ViewState["sort"] = SortDirection.Descending;
fillData(e.SortExpression.ToString() + " asc");
}
else
{
ViewState["sort"] = SortDirection.Ascending;
fillData(e.SortExpression.ToString() + " desc");
}
}

Thanks,
Sun Rays

How to insert text in GridView ?

squattyarun30-Oct-07 23:13

squattyarun

30-Oct-07 23:13

I want to insert text in gridview but i dont have any data source. How can I insert text values in dataGridview? for example if i want to insert value in textbox i will user textBox1.text="Adfsr" like in the same way i want to create a gridview i have two columns viz Name and description in datagridview and I want to insert in "Arun" in name field and "Healthy person" in description. please suggest.
I want to use dataGridview only....

Arun Singh
Noida.

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