|
Hi,
i'm just guessing, but what if you try to use it like a query?
... new OdbcCommand("Call Proc...
// remove this line - oCmd.CommandType = CommandType.StoredProcedure;
OdbcDataReader dbReader = oCmd.ExecuteReader();
// access the first row and first column to get the result
if you run the command within ISQL you got the result displayed like a table, or not?
Regards
Sebastian
P.S.: Next time you should post this to the General Database forum!
|
|
|
|
|
Dear Expert,
My website worked fine on local machine but throw an exception when running on hosting. Please look at following exception.
Some infomations about my site:
- Asp.net 2.0.
- Used Eucalypto open source, dll file (NHibernate).
- MsSql 2005.
Any help is appreciate!
Exception here:
NHibernate.MappingException: Could not compile the mapping document: Eucalypto.Forum.Message.hbm.xml.
System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.ReflectionPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
Thanks,
Nhan
|
|
|
|
|
Try setting the trust level[^] to FULL. If that is not working, I believe you need to contact the hosting provider.
|
|
|
|
|
Thanks Navaneeth, thank you for your replying quickly.
I tried to set trust level to FULL but it was not work. And I contacted with the hosting provider, the problem was solved .
Nhan
|
|
|
|
|
all the permission has been set in containing folder?
Anshuman Singh
|
|
|
|
|
please use
<trust> level="[Full]"
originUrl="URL"
processRequestInApplicationTrust = "[True]"
/>
Anshuman Singh
|
|
|
|
|
Hi,
Is there any way to fill datatable with value form a repeater?
thanks in advance
|
|
|
|
|
What is the data source for repeater? You can iterate it and add rows to a DataTable.
|
|
|
|
|
ya. i solved it. thanks for your reply
|
|
|
|
|
Hello Experts,
There are some date columns in my data grid. The data in a date column is like below:
"01/11/2010"
But when I press the update button on the gridview then the edititemtemplate directly converts the data as:
"01/00/2010"
What is the problem??..Please help...
|
|
|
|
|
from where this value come 01/11/2010 wat code u use for it..
|
|
|
|
|
I havent used it.. The update code of the gridview is like below.There is no mistake...
UPDATE [CP_MASTER]
SET [ORDERNUMBER] = @ORDERNUMBER,
[NEWRPT] = @NEWRPT,
[UNICLODEL] = CAST(@UNICLODEL as smalldatetime),
[SUPPLDEL] = @SUPPLDEL,
[CUSTOMER] = @CUSTOMER,
[DEPARTMENT] = @DEPARTMENT,
[SUPPLIER] = @SUPPLIER,
[LINE] = @LINE,
[COLORS] = @COLORS,
[QTY] = @QTY,
[NOTES] = @NOTES,
[RATIO] = @RATIO,
[WC] = @WC,
[KIMBALL] = @KIMBALL,
[LAPDIPSENT] = @LAPDIPSENT,
[LAPDIPAPPRV] = @LAPDIPAPPRV,
[WASH] = @WASH,
[WASHTYPE] = @WASHTYPE,
[PRINTX] = @PRINTX,
[PRINTAPPRV] = @PRINTAPPRV,
[EMB] = @EMB,
[EMBAPPRV] = @EMBAPPRV,
[BULKFABRICARRV] = @BULKFABRICARRV,
[FITSENT] = @FITSENT,
[FITAPPRV] = @FITAPPRV,
[SIZESETSENT] = @SIZESETSENT,
[SIZESETAPPRV] = @SIZESETAPPRV,
[SEALERSENT] = @SEALERSENT,
[SEALERAPPRV] = @SEALERAPPRV,
[BULKFABRICTEST] = @BULKFABRICTEST,
[GARMENTTEST] = @GARMENTTEST,
[CUTDATE] = @CUTDATE,
[SEWING] = @SEWING,
[MIDINSPECTION] = @MIDINSPECTION,
[PRODSENT] = @PRODSENT,
[PRODAPPRV] = @PRODAPPRV,
[INSPECTIONDATE] = @INSPECTIONDATE,
[STATUS] = @STATUS
WHERE [ORDERDATE] = @ORDERDATE AND [ONUNICLO] = @ONUNICLO AND [STYLE] = @STYLE AND [MERCH] = @MERCH
|
|
|
|
|
Hello All,
I have a hardcoded datatable ,i want to return this datatable in form of dataset which i have to bind a gridview.
Please tell me how can i do this
Thanks in advance
Ritz
|
|
|
|
|
you can directly bind the datatable with grid. Is there any special reason for binding dataset?
|
|
|
|
|
gridvew1.datasourse = dt;
directly bind it with grid view.
|
|
|
|
|
When i run the .Net program, the IE was half sized. How to get the fully sized window while executing the project?
|
|
|
|
|
use following script in your head tag
you problem will be resolved.....
<script language="javascript" type="text/javascript">
window.moveTo(0, 0);
window.resizeTo(screen.width, screen.height)
</script>
umerumerumer
|
|
|
|
|
S. Its working.Thank u for your help.
|
|
|
|
|
this is the good answer
Anshuman Singh
|
|
|
|
|
Hi,
I am working with an multilingual site.
The main language of site is english and the second language is chinese.
I am keeping the culture in session.A user changes the culture using the link buttons provided. Now my problem is that when after changing the culture if user presses the browsers back button, the culture changed to old culture.
First the culture was in english, changed to chinese and press back button the culture changes to english again but it is supposed to be in chinese.
Any suggestion how to maintain culture ?
I m not using profiles.
Regards
Vijay V.
Yash Softech
|
|
|
|
|
hi Everyone,
I am creating an application that gets data from specific griedview columns and export the data to an excel spreadsheet 9that is located though a fileupload control.
After i execute the code I find that the spreadsheet was not populated. Please exemine my code below, your help will be appreciated. Thanks
Protected Sub Export_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Export.Click<br />
<br />
Dim xConnStr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _<br />
"Data Source=" & Server.MapPath("TemplateWDataNEW.xls") & ";" & _<br />
"Extended Properties=Excel 8.0;"<br />
<br />
<br />
Dim objXConn As New OleDbConnection(xConnStr)<br />
objXConn.Open()<br />
<br />
For Each gvRow As GridViewRow In gvClients.Rows<br />
<br />
Dim strRoom1 As String = "INSERT INTO [Sheet2$](tvlr_Lastname, tvlr_Firstname,tvlr_title) values (@Surname,@FName,@Title)"<br />
Dim InsertCommand As New OleDbCommand(strRoom1, objXConn)<br />
<br />
InsertCommand.Parameters.AddWithValue("@Surname", gvRow.Cells(0).Text)<br />
InsertCommand.Parameters.AddWithValue("@FName", gvRow.Cells(1).Text)<br />
InsertCommand.Parameters.AddWithValue("@Title", gvRow.Cells(2).Text)<br />
InsertCommand.ExecuteNonQuery()<br />
Next<br />
objXConn.Close()<br />
<br />
End Sub
allphpro
modified on Tuesday, February 17, 2009 5:22 AM
|
|
|
|
|
is there any way that i can change the "select" text which appears when i "enable selection" in a grid view ? I want to change it to "Delete" or some other word..
Thank you !
|
|
|
|
|
Are you using asp:commandfield as a column template?
If yes, you have the following properties:
CancelText
DeleteText
EditText
InsertText
NewText
SelectText
UpdateText
Calin
|
|
|
|
|
I am using a repeater control in my project. How to display only the first 2 data items using the orderby method.
|
|
|
|
|
use Select Top 2 .... order by ...
in query and bind the datatable into the Repeater..... simple.
Abhishek Sur
|
|
|
|