|
Member 2842468 wrote: I am new in develoment
Someone who is 'new to development' should not be written commercial code and sure as hell should not be writing permissions systems. The people paying you a pittance are going to get exactly the system they deserve, but when reality sets in, you will be out of a job unless you do some work to build a basic skillset.
Christian Graus
Driven to the arms of OSX by Vista.
|
|
|
|
|
how to resize the gridview header in runtime?
send me usefull URL's.
Chandhu
|
|
|
|
|
Google[^]
The word "politics" describes the process so well: "Poli" in Latin meaning "many" and "tics" meaning "bloodsucking creatures."
जय हिंद
|
|
|
|
|
hi , help me in executing a procedure with out parameters ,i have tried like this , i need to declare a out put parameter.
declare @para_ok numeric(5,0)
exec dbo.procname 59171, @para_ok output
private void GenerateCSVFile()
{
int intStatus = -1;
for (i = 1; i < ddlDraw.Items.Count; i++)
{
OdbcCommand oCmd = new OdbcCommand("{"+ intStatus +"=call procname (" + ddlDraw.Items[i].Text + ")}", conn);
oCmd.CommandType = CommandType.StoredProcedure;
try
{
conn.Open();
oCmd.ExecuteNonQuery();
}
catch
{
valSuccessMsg.ErrorMessage = "File is not generated.";
valSuccessMsg.IsValid = false;
}
finally
{
valSuccessMsg.ErrorMessage = "File is generated successfully for STT Game.";
valSuccessMsg.IsValid = false;
conn.Close();
}
}
}
|
|
|
|
|
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
|
|
|
|
|