|
the_chabo wrote: first of all i want to express how useful these forums are and thank everyone for his help
Awww, thanks
Let me think out your question you have
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
select HataKodu,HataAciklama,Count(HataKodu) as Toplam From Tablom Where HataKodID<>0 group by HataKodu,HataAciklama Order by HataAciklama Asc;
select HataKodu2,HataAciklama2,Count(HataKodu2) as Toplam From Tablom Where HataKodID2<>0 group by HataKodu2,HataAciklama2 Order by HataAciklama2 Asc;
select HataKodu3,HataAciklama3,Count(HataKodu3) as Toplam From Tablom Where HataKodID3<>0 group by HataKodu3,HataAciklama3 Order by HataAciklama3 Asc;
select HataKodu4,HataAciklama4,Count(HataKodu4) as Toplam From Tablom Where HataKodID4<>0 group by HataKodu4,HataAciklama4 Order by HataAciklama4 Asc;
how to 4 sql command to reduce 1 sql command?
Thanks
|
|
|
|
|
do it inside a procedure and execute the procedure
|
|
|
|
|
|
eraydeniz wrote:
That isn't very nice. The guy tries to help you and you respond with a MAD face. If the answer is not the one you seek then perhaps you need to ask a better question.
|
|
|
|
|
That was a fair suggestion show some respect sir.
|
|
|
|
|
Exactly, I don't understand the mad face for a decent response.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
eraydeniz wrote: how to 4 sql command to reduce 1 sql command?
That doesn't make much sense.
Depending on how that should be interpreted there are two answers I can think of:
You could UNION the results together to form one result set.
OR
You could just execute it all in on SqlCommand and get 4 result sets back, but it is sent as one SqlCommand.
|
|
|
|
|
Could You please provide me with solution
I have a panel and only one control on it - WebBrowser control. When I try to access to webBrowser.name is OK, but webBrowser.Url == null
WebBrowser webBrowser = webBrowserTabControl.SelectedPanel.Controls[0] as WebBrowser;<br />
webBrowsersCollection.SelectedWebBrowser = webBrowser.Name;<br />
currentURL = webBrowser.Url.ToString();
Thanks in advance
|
|
|
|
|
Have you browsed to a URL? If not, the Url property is going to be null. You should check this before calling the ToString() method on the Uri object instance.
Paul Marfleet
|
|
|
|
|
Thank for all
I created additional dictionary to collect URL, becouse it seems to me that WebBrowswer has URL property resolved after "web paged displayed", But I can't create additional thread to wait while it will be finised
-- modified at 8:29 Thursday 1st November, 2007
|
|
|
|
|
probably because it has no url set?
fafafa, ringakta icke sådant som bringa ack så naggande högönsklig välmåga å baronens ära.
|
|
|
|
|
HI,
i've got a DataGridView to which i load data from a file.
i like to know how can i change the color of a cell (or the text)
the idea is :
when i load the data i check a certain cell an if it's Value <0 then i like
to see the (Value in a Red Color)
i'm using this kind of insert to the datagridview :
<br />
for(....)<br />
{<br />
string cColumn1 = value;<br />
string cColumn2 = value;<br />
.<br />
.<br />
.<br />
<br />
Object [] rRow = { cColumn1 ,cColumn1 };<br />
dataGridView1.Rows.Add(rRow);<br />
}<br />
THNKS in Advance
Have Fun
Never forget it
|
|
|
|
|
|
Please don't cross post. It's not very polite.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Hi, I am using VS 2005.
I need to display an image in my web form.
i am giving the Image URL as a .aspx file(say Image.aspx)
In Image.aspx, i am creating & saving an image & writing the code to save as Response.OutputStream.
In local server, its working fine but after diployment its giving an error as Cannot convert type 'ASP.templates_image_aspx' to 'System.Web.UI.WebControls.Image'
What shall i do.. Please help me..
Regards,
JaiShankar
|
|
|
|
|
jaishankar2704 wrote: local server, its working fine but after diployment its giving an error
Is the deployment machine configured the same as the local machine?
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
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
|
|
|
|
|
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>
:-
|
|
|
|