ASP.NET Discussion Boards

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

Re: stored procedure return no data

eyeseetee3-Jul-08 2:52

eyeseetee

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

Re: stored procedure return no data

michael_jhons3-Jul-08 3:42

michael_jhons

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

Re: stored procedure return no data

eyeseetee3-Jul-08 4:08

eyeseetee

3-Jul-08 4:08

have you got this declared at the top:

using System.Data.SqlClient;

We are not a Code Charity

Re: stored procedure return no data

michael_jhons3-Jul-08 4:15

michael_jhons

3-Jul-08 4:15

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

Re: stored procedure return no data

eyeseetee3-Jul-08 4:29

eyeseetee

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

Re: stored procedure return no data

michael_jhons3-Jul-08 4:35

michael_jhons

3-Jul-08 4:35

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

Re: stored procedure return no data

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.

Re: stored procedure return no data

michael_jhons3-Jul-08 21:15

michael_jhons

3-Jul-08 21:15

thank you sherine and netman,
i found the problem

regards

Controls are not positioned properly

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

eyeseetee

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

Inserting new record in RADgridcontrol

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

eyeseetee

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

Re: Inserting new record in RADgridcontrol

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

eyeseetee

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

Problem showing image in an web report using crystal report

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

eyeseetee

3-Jul-08 2:49

WHat does the error say?

We are not a Code Charity

Re: crystal reports in aspx

Puneri6-Jul-08 2:48

Puneri

6-Jul-08 2:48

Unable to cast object of type 'CrystalDecisions.ReportSource.NonHTTPCachedReportSource' to type 'CrystalDecisions.CrystalReports.Engine.ReportDocument'

javascript problem in asp.net 2.0

vijaylumar3-Jul-08 0:48

vijaylumar

3-Jul-08 0:48

hai friends
i have a page"FramePage.aspx"
in that i took two "iframes" namely "iframe1" and "iframe2"
iframe1 has src as default.aspx page and iframe2 has src as default2.aspx
default.aspx refreshes per 2min
after refrshing i raise buttonclick event of default2.aspx page thru default.aspx
for that i written javascript like this

//this function takes a value (ltext) and transmits that to the left hand frame

function tranRight(ltext)

{
//parent.frames("frame1").document.forms("form2").item("TextBox1").value = ltext;
parent.frames("frame1").document.getElementById('Button1').click();

}

and in defaultpage in page load event
i written
ClientScript.RegisterStartupScript(GetType(Capture), "close", "tranRight('upload');", True)

its working fine in localhost
but when i upload it into website it doesnt work

what would be the problem
it is working in localhost but not in website

plz help me
thanks in advance
vijay

Error:Type and identifier are both required in a foreach statement

rockram3-Jul-08 0:20

rockram

3-Jul-08 0:20

Code:
foreach ( strSuggestion in functionReturnValue)
{
dblSimilarity = WordSimilarity(strWord, strSuggestion);
i = intSuggestionCount;
while (dblSimilarity > dblSimilarityArray(i))
{
if (i < intSuggestionCount)
{
strSuggestionArray(i + 1) = strSuggestionArray(i);
dblSimilarityArray(i + 1) = dblSimilarityArray(i);
}
strSuggestionArray(i) = strSuggestion;
dblSimilarityArray(i) = dblSimilarity;
i = i - 1;
if (i == -1)
{
break; // TODO: might not be correct. Was : Exit Do
}

}
}

functionReturnValue = strSuggestionArray;

return functionReturnValue;
return functionReturnValue;
}

Re: Error:Type and identifier are both required in a foreach statement

Sherin Iranimose3-Jul-08 0:21

Sherin Iranimose

3-Jul-08 0:21

rockram wrote:
foreach ( strSuggestion in functionReturnValue)

foreach (String strSuggestion in functionReturnValue)

EVEN THE WORD IMPOSSIBLE SAYS I M POSSIBLE.

Decrypt password

Member 38798812-Jul-08 23:53

Member 3879881

2-Jul-08 23:53

Hi use this code i have encrypted my password:

private string EncryptPassword(string Password)
{
System.Security.Cryptography.SHA1CryptoServiceProvider objcrypwd = new System.Security.Cryptography.SHA1CryptoServiceProvider();
byte[] Encr = objcrypwd.ComputeHash(System.Text.Encoding.UTF8.GetBytes(Password));
return Convert.ToBase64String(Encr);
}

Now i like to decrypt ther password,
Any one help me to decrypt...,

Thanks & Regards,
NeW OnE,
please don't forget to vote on the post

Re: Decrypt password

Sherin Iranimose3-Jul-08 0:16

Sherin Iranimose

3-Jul-08 0:16

I don't think, We will get a hashed data to original format D'Oh! | :doh: