|
HI All,
Can any one tell or provide links, whether Exbedded supports .Net Framework 2.0
Thanks,
Urs Friend
|
|
|
|
|
Which specific features do you want to support?
Best regards,
Jaime.
|
|
|
|
|
hi folks,
A SP in sql server is not returning a string variable as output variable ..can any1 let me know how to return a string variable from SP in sql server?A function returns a string variable whereas a SP doesnt return.y?
for e.g I have created a SP
create procedure SP_abc(
@a INT
@b out VARCHAR(10)
)
as
begin
set @b = 'ABCD'
end
How to get the value of b in the front end?
T.Balaji
|
|
|
|
|
If you fire the SP with SqlCommand.ExecuteNonQuery(), then you can retrieve the parameter with SqlCommand.Parameters collection as:
SqlCommand command = new SqlCommand("SP_abc");
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@a", SqlDbType.Int);
command.Parameters["@a"].Value = somevaluehere;
command.ExecuteNonQuery()
string b = (string)command.Parameters["@b"];
Best regards,
Jaime.
|
|
|
|
|
hi,
But im getting a value as 1 and 0 and im not getting the value of though im usign LINQ.Can u tell me whether it is possible to return a string value as output in the front end using SP?
T.Balaji
|
|
|
|
|
|
Technically it is possible to emulate them with the graphic libraries, but their is no native support for graphing. You can either create your own custom controls or look into a third-party control that may have what you are looking for.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my Blog
|
|
|
|
|
Hi,
I am developing a demo application using Microsoft Composite UI Application Block and Smart Client Software Factory. I am using Access as the database & want to show the one of the tables in the DataGridView.
I have no clue as how I should do this. Can any one help in the same?
Thanks in advance,
HR
|
|
|
|
|
There are several Database beginner level tutorial type articles here on CodeProject. I suggest you take a look at one or more of them.
See in the site menu bar CHAPTERS section and the subsection Database
led mike
|
|
|
|
|
I want to write a voice response system with C#.NET. But I don't know where I should start? Which component is better and easier to use (why?) and What is the difference between them? Also please say the differences between kdtele , tapi , tapiex?
Please help me.
|
|
|
|
|
Not sure which is better. Have you researched the different components and weigh out the pro's and con's?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Hi,
I already added an image button in Edit Item Template.
I created calendar in Edit Item Template, i make it invisible.
How to show calendar whenever image button clicked in datagrid????
Thanks,
usha
|
|
|
|
|
A possibility:
Investigate using AJAX and embed an UpdatePanel in the EditItemTemplate containing the calendar with it's visible property set to false . When the image click event is fired, set the calendar's visible property to true to show the calendar.
Good luck...
/F - .NET Developer
|
|
|
|
|
Hi,
Thanks for ur reply...
Calendar drpDgTrType = (Calendar )Datagrid1.FindControl("drpDgTrType");
drpDgTrType.visible = true;
However, i got Object reference not set to an instance of an object error when
i run the codes.
Please help...
regards,
usha
|
|
|
|
|
On Row Create set the Command Arg to the row index.
On the Command event of the gridview, set the command name of the Image button to ImgClicked or any thing you like.
In the Method of the Command event.
if (e.CommandName == "ImgClicked")
{
((Calendar)GridView.Rows[e.CommandArgs].FindControl("drpDgTrType")).visible = true;
}
Well more or less.
Hope it helps.
|
|
|
|
|
Use the following code:
Dim Cal As Calendar = CType(Dtgrd.Items(Dtgrd.EditItemIndex).FindControl("CalndrName"), Calendar)
Cal.Visible = True
|
|
|
|
|
Hi,
Is it possible to set a collapse/expand functionality in a ListView filled with ListViewGroups ?
Thanks,
Lilia
|
|
|
|
|
Lilia Drouot wrote: Is it possible to set a collapse/expand functionality in a ListView filled with ListViewGroups ?
Not that I am aware of. Have you considered using a PropertyGrid?
led mike
|
|
|
|
|
While i am executing the below query, i have "cann't find Table 0" ERROR.SO please rectify my errors.
Sub ReportInvoiceDetails(ByVal InvNo As String)
Try
Qry = "Select Invoice_Master.Im_InvNo,Invoice_Master.Im_InvDate, Invoice_Master.Im_JobCardno, Invoice_Master.Im_PartyName, Invoice_Master.Im_Address, Invoice_Master.Im_Reg, Invoice_Master.Im_Make, Invoice_Master.Im_Model, Invoice_Master.Im_Mileage, Invoice_Master.Im_Rono, Invoice_Master.Im_Payments,Invoice_Particulars.Ip_Sno,Invoice_Particulars.Ip_Desc,Invoice_Particulars.Ip_Qty,Invoice_Particulars.Ip_Rate,Invoice_Particulars.Ip_1amt,Invoice_Particulars.Ip_2amt,Invoice_Particulars.Ip_Labour,Invoice_Amount.Ia_Sub1, Invoice_Amount.Ia_Sub2, Invoice_Amount.Ia_Sub3, Invoice_Amount.Ia_Total, Invoice_Amount.Ia_Vatper, Invoice_Amount.Ia_VarAmt, Invoice_Amount.Ia_Gtotal FROM (Invoice_Master INNER JOIN Invoice_Particulars ON Invoice_Master.Im_InvNo = Invoice_Particulars.Ip_InvNo) INNER JOIN Invoice_Amount ON Invoice_Master.Im_InvNo = Invoice_Amount.Ia_InvNo WHERE Invoice_Master.Im_InvNo='" & InvNo & "' ORDER BY Invoice_Particulars.Ip_Sno "
'Qry = "select Invoice_Master.Im_InvNo,Invoice_Master.Im_JobCardno,Invoice_Master.Im_PartyName,Invoice_Master.Im_Address,Invoice_Master.Im_Address,Invoice_Master.Im_Reg,Invoice_Master.Im_Make,Invoice_Master.Im_Model,Invoice_Master.Im_Mileage,Invoice_Master.Im_Rono from Invoice_Master WHERE Invoice_Master.Im_InvNo='" & InvNo & "' "
'MessageBox.Show(Qry)
DsInvoice = objdal.returnDataset(Qry)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
Try
Qry = "delete from Tbl_Temp"
objdal.ExeQuery(Qry)
Dim dsrowcount, col, i, j As Integer
dsrowcount = DsInvoice.Tables(0).Rows.Count
For i = 0 To dsrowcount - 1
Qry = "insert into Tbl_Temp(Im_InvNo,Im_InvDate,Im_JobCardno,Im_PartyName,Im_Address,Im_Reg,Im_Make,Im_Model,Im_Mileage,Im_Rono,Im_Payments,Ip_Sno,Ip_Desc,Ip_Qty,Ip_Rate,Ip_1amt,Ip_2amt,Ip_Labour,Ia_Sub1,Ia_Sub2,Ia_Sub3,Ia_Total,Ia_Vatper,Ia_VarAmt,Ia_Gtotal)values( LTRIM('" & DsInvoice.Tables(0).Rows(i)(0) & "'),LTRIM('" & DsInvoice.Tables(0).Rows(i)(1) & "'),'" & DsInvoice.Tables(0).Rows(i)(2) & "','" & DsInvoice.Tables(0).Rows(i)(3) & "','" & DsInvoice.Tables(0).Rows(i)(4) & "','" & DsInvoice.Tables(0).Rows(i)(5) & "','" & DsInvoice.Tables(0).Rows(i)(6) & "','" & DsInvoice.Tables(0).Rows(i)(7) & "','" & DsInvoice.Tables(0).Rows(i)(8) & "','" & DsInvoice.Tables(0).Rows(i)(9) & "','" & DsInvoice.Tables(0).Rows(i)(10) & "','" & DsInvoice.Tables(0).Rows(i)(11) & "','" & DsInvoice.Tables(0).Rows(i)(12) & "'," & DsInvoice.Tables(0).Rows(i)(13) & "," & DsInvoice.Tables(0).Rows(i)(14) & "," & DsInvoice.Tables(0).Rows(i)(15) & "," & DsInvoice.Tables(0).Rows(i)(16) & "," & DsInvoice.Tables(0).Rows(i)(17) & "," & DsInvoice.Tables(0).Rows(i)(18) & "," & DsInvoice.Tables(0).Rows(i)(19) & "," & DsInvoice.Tables(0).Rows(i)(20) & "," & DsInvoice.Tables(0).Rows(i)(21) & "," & DsInvoice.Tables(0).Rows(i)(22) & "," & DsInvoice.Tables(0).Rows(i)(23) & " )"
' MessageBox.Show(Qry)
objdal.ExeQuery(Qry)
Next
Qry = "Select * from Invoice_Master"
DsInvoiceNew = objdal.returnDataset(Qry)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try
End Sub
|
|
|
|
|
Qry = "delete from Tbl_Temp"
shouldn't be there some argument after delete ?
like: delete * from tbl_temp
|
|
|
|
|
So where do you get the error? That should gve some clue.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I am developing a Windows application which has login form where user can enter userid & password. The same will be checked against the database for verification.
I want to know how the password should be stored in database in Encrypted format? Also, how to retrive such encrypted data in WinForm?
I am currently using SQL 2005 as database. Later the database may changed to Oracle 10g. Will the database change affect the coding at UI level?
If anyone can give me any suggestions on the same, that would be great.
Thanks in advance
HR
|
|
|
|
|
A common way of doing this is by using a one-way hash on the password before storing in the database. You can use this:
FormsAuthentication.HashPasswordForStoringInConfigFile
to do that. When the user enters a password, its hashed again and the hashes are compared. Using this approach though, you can never get back to plain text password. If a user forgets it, a new one must be created.
Regards,
Rob Philpott.
|
|
|
|
|
What's the best way for an application to store credentials if they need to be recoverable (for transmission elsewhere)? One-way hashes are great if all the application has to do is validate credentials when they are re-entered. But what about when some other device will need the real credentials?
|
|
|
|
|
You could use an encryption algorithm one-way on the "less secure" server, treating the result like you would a hash. Your "more secure" server could then decrypt a token from the "less secure" server to retrieve the password.
This lets you keep only the public half of the key on the "less secure" server. Presumably you'd also be salting the password, which the "more secure" server could ignore.
|
|
|
|
|