|
use the itemdatabound to change the value.
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
we are using oracle not sql server('@symbol is not supported in Oracle').
give me the solution
|
|
|
|
|
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..i dont want to delete it.just pass a link.
alok2171
|
|
|
|
|
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>
:-
|
|
|
|
|
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
|
|
|
|
|
|
THANKS
i did not saw it becaude i was missing th IO
THNKS
Have Fun
Never forget it
|
|
|
|
|
Glad to help you
|
|
|
|
|
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.
|
|
|
|
|
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
|
|
|
|
|
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 )
|
|
|
|
|
Seems like i missed something
My current favourite word is: Waffle
Cheese is still good though.
|
|
|
|
|
I told you this was rude and inappropriate and you decided that must mean you should post it to some other forums as well ?
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 )
|
|
|
|
|
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
|
|
|
|
|
I can able to asign values most of the function except choice element in XSD
Thanks
Warm Regards
Prakash-B
|
|
|
|
|
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 ?
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 )
|
|
|
|
|
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
|
|
|
|
|
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."
|
|
|
|
|
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();
}
}
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
First You should take 2 textboxes and one button..
then write the following code Globally....
static DataSet ds = new DataSet();
static DataTable dt=new DataTable();
and in pageload event you should paste this code
if(!IsPostBack)
{
dt.Columns.Clear();
ds.Clear();
dt.Rows.Clear();
dt.Columns.Add("Name");
dt.Columns.Add("Number");
ds.Tables.Clear();
ds.Tables.Add(dt);
DataGrid1.DataSource =ds;
DataGrid1.DataBind();
}
and Write code for button1..
DataRow r=dt.NewRow();
r[0]=TextBox1.Text;
r[1]=TextBox2.Text;
ds.Tables[0].Rows.Add(r);// dt.Rows.Add(r);
DataGrid1.DataSource =ds;
DataGrid1.DataBind();
venki
|
|
|
|