ASP.NET

stored procedure return no data

3-Jul-08 3:22

1. Create a Listbox
2. Populate it with values
3. Write a query which selects * from a table where the criteria meets what the user has entered.
Make sure the query is a stored procedure not inline else it could be open to SQL injection attack.

let us know once you have done that

We are not a Code Charity

michael_jhons3-Jul-08 2:46

3-Jul-08 2:46

hello,

i created a code that call a stored procedure, the problem is that in windows form it's working fine, ut in web form my filled DataTable remain 0 rows count

here is the code:

DataTable dtRept=new DataTable();<br />
DataTable dtagntInfo= new DataTable();<br />
string dateTm=DateTime.Now.ToString("d/M/yyyy");<br />
SqlConnection cnDigitalk=new SqlConnection("datasource=111.111.111.111;initial catalog=NORTHWIND;USER ID=SOMEID;PASSWORD=SOMEPASSWORD");<br />
SqlCommand cmd=new SqlCommand("sp_name",cnDigitalk);<br />
cmd.CommandTimeout=0;<br />
cmd.CommandType=CommandType.StoredProcedure;<br />
cmd.Parameters.Add("@datetime_from",SqlDbType.DateTime).Value= dateTm +" 00:00:01 AM";<br />
cmd.Parameters.Add("@datetime_to",SqlDbType.DateTime).Value= dateTm +" 11:59:59 PM";<br />
SqlDataAdapter daReport=new SqlDataAdapter(cmd);<br />
daReport.Fill(dtRept);

in webform: dtRept.Rows.Count=0

pleas if someone could help
thanks in advance and best regards

eyeseetee3-Jul-08 2:52

3-Jul-08 2:52

SqlCommand cmdsql = new SqlCommand("select_all_from_table", con);
cmdsql.CommandType = CommandType.StoredProcedure;

SqlDataAdapter dataAdapteritems = new SqlDataAdapter();
dataAdapteritems.SelectCommand = cmdsql;
DataSet dataSetitems = new DataSet();
dataAdapteritems.Fill(dataSetitems);
DataTable dtitems = dataSetitems.Tables["table"];

something like that, try that

We are not a Code Charity

michael_jhons3-Jul-08 3:42

3-Jul-08 3:42

again this code worked on the windows form but not in my web form, do you think is it a mater of configuration, the code is seeing the stored procedure but it's not returning any value

thanks for helping

eyeseetee3-Jul-08 4:08

3-Jul-08 4:08

have you got this declared at the top:

using System.Data.SqlClient;

We are not a Code Charity

michael_jhons3-Jul-08 4:15

3-Jul-08 4:15

yes of course other wise it will give me an error using sqlconnection and sqlDataAdapter

eyeseetee3-Jul-08 4:29

3-Jul-08 4:29

I'm really stuck then, is your connection string formatted correctly for the web form?
Apart from that I'm not sure, Ive got the same code working on my page

We are not a Code Charity

michael_jhons3-Jul-08 4:35

3-Jul-08 4:35

i'm also that turned my head upside down, anyway thank you for your concern.
Regards

Sherin Iranimose3-Jul-08 4:46

Sherin Iranimose

3-Jul-08 4:46

Where you are using 'dtRept'?

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

michael_jhons3-Jul-08 21:15

Controls are not positioned properly

3-Jul-08 21:15

thank you sherine and netman,
i found the problem

regards

BalasubramanianK3-Jul-08 2:10

BalasubramanianK

3-Jul-08 2:10

In my web page, I have two buttons for Submit (Web control) and Close (Html button). If I open my web page as maximized size, it is placed well at the bottom of the page. If I minimize the form, it is misplaced at middle of my web page. In that page, I am using 2 table contents. I used these button inside the table and outside the table both. I didn't get proper solution. What I have to do? Thanks in adv.

Balasubramanian K.

Re: Controls are not positioned properly

eyeseetee3-Jul-08 2:40

Inserting new record in RADgridcontrol

3-Jul-08 2:40

The reason that the button moves around the page is because you havent got its location attribute as 'fixed' instead you probably have it as 'absolute'

We are not a Code Charity

madhavi.kona3-Jul-08 2:09

madhavi.kona

3-Jul-08 2:09

Hi,

Iam using telerik radgrid control in my application.

iam using the following code in my application.

// arraylist with one record

arraylist al=new arraylist();
al.add(new("fsf"));

// binding radgrid control with arraylist
radgrid1.datasource=al;

my problem is , i have one textbox and one button on the same page.if i click button the value in textbox will be inserted in radgrid1(radgrid control not gridview).

thanks in advance.

madhavi.kona

Re: Inserting new record in RADgridcontrol

eyeseetee3-Jul-08 2:41

Re: Inserting new record in RADgridcontrol

3-Jul-08 2:41

madhavi.kona wrote:
.if i click button the value in textbox will be inserted in radgrid1(

Do you mean you want to do this or you have already done this?

We are not a Code Charity

madhavi.kona3-Jul-08 3:23

madhavi.kona

3-Jul-08 3:23

i want to insert record in to the radgridcintrol
can u help me.

madhavi.kona

Re: Inserting new record in RADgridcontrol

eyeseetee3-Jul-08 3:24

Problem showing image in an web report using crystal report

3-Jul-08 3:24

bind the control to a datatable which has been populated with field from your table.

We are not a Code Charity

CrazyCoder263-Jul-08 1:41

CrazyCoder26

3-Jul-08 1:41

Hi,I have created an web report using crystalreport.There is an image(for barcode) field in this report.The crystal report datasource is from an xml schema.The datatype of that image field is base64Binary.But the problem is that when I am showing that report with Crystal Report Viewer,the image field is shown empty.But when I Print the report or export the report to any format,it shows the Image(Barcode) properly.Do you have any solution to this problem guys.I am clueless.I have been with this problem for last 3days.Plz help me out.

ARINDAM

ARINDAM

crystal reports in aspx

Puneri3-Jul-08 1:27

Puneri

3-Jul-08 1:27

Hi I'm using crystalreportviewer on my page. I need to save report as word document on server.
I've written following code. but I'm getting error at highlighted line.
CrEmReport is crystalreportviewer object.

Me.CrEmReport.ParameterFieldInfo.Clear()
Me.CrEmReport.ReportSource =Server.MapPath("EmCallupReport.rpt")
Dim ParamFields As ParameterFields = Me.CrEmReport.ParameterFieldInfo
Dim emTicketId As New ParameterField
emTicketId.Name = "VTICKETID"
Dim emTicketId_Value As New ParameterDiscreteValue
emTicketId_Value.Value = objTicket.ticketId
emTicketId.CurrentValues.Add(emTicketId_Value)
ParamFields.Add(emTicketId)
For Each cnInfo As TableLogOnInfo In Me.CrEmReport.LogOnInfo
cnInfo.ConnectionInfo = ConnInfo

Next
    Dim strDate As String = Convert.ToString(objTicket.emRaisedDate)
    Dim objReportDoc As New ReportDocument
    <big>objReportDoc = CrEmReport.ReportSource</big>
    objReportDoc.ExportToDisk(ExportFormatType.PortableDocFormat, "\\app_data\\uploads\\Reports\\Emergency\\Emergency_" & objTicket.deptName & "_" & strDate)

Please someone help me with this code.
Thanks in advance,
Puneri

Re: crystal reports in aspx

eyeseetee3-Jul-08 2:49