Re: InStr in C# - ASP.NET Discussion Boards

how to check the rocord exsist in the database

biswa4720-Aug-07 21:08

20-Aug-07 21:08

hi guyz

again i need ur help.

i have a table emp.where the coloumns are
emp_id,emp name and address.

i am storing the data to "emp" table from the frontend throgh storepocedure.there is a "check" button, in which i want to check the data from the database based up on the empid.
i want to check if there is any record based up on the empid from emp table.it should give a message that "one reocrd found" .
where i am entering the empid in the "textbox1.text".what will be code for it in "vb.net"

Re: how to check the rocord exsist in the database

Michael Sync20-Aug-07 21:25

Michael Sync

20-Aug-07 21:25

In Stored Procedure,

"SELECT COUNT(*) FROM emp WHERE emp_id = @empID

Use SqlCommand or OledbCommand to execute the stored procedure. Get the return value and show it to the user.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.

Re: how to check the rocord exsist in the database

imranafsari20-Aug-07 22:56

imranafsari

20-Aug-07 22:56

are u taking about how to execute sp in dotnet.

here code in C#

setting = ConfigurationManager.ConnectionStrings["databaseConnectionString"];
if (setting != null)
{
conn = new SqlConnection(setting.ConnectionString);
cmd = new SqlCommand("Sp_Category_check");
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cateid", SqlDbType.VarChar);
cmd.Parameters["@cateid"].Value = DropDownList1.SelectedValue;
conn.Open();
cmd.Connection = conn;
try
{
rdr = cmd.ExecuteReader();
if (rdr.Read())
{
//here your message comes
}
}
catch (SqlException ex)
{
Response.Write(ex.ToString());
}
finally
{
if (rdr != null)
{
rdr.Close();

}
if (conn != null)
{
conn.Close();
}
}

imaran khan

Problem with ASP.Net menu control - leaving a top margin of about 1 or 2px in IE

ChrisFarrugia20-Aug-07 21:06

ChrisFarrugia

20-Aug-07 21:06

Dear All,

I am trying to use the asp.net menu control in order to create a horizontal menu made up of images.

I have a table which has 3 columns and 1 row. the first cell is used to hold an image that does not have to do with the menu, the second cell holds a table that contains the menu while the third cell contains another independent image. All cellpadding and cellspacing and border are set to 0.

Now what is happening is that the menu cell is leaving a margin at the top of arount 1 or 2 pixels. All the images used in the row are the same height even the other images that do not have to do with the menu.

Everthing looks fine in mozilla! the problem is with IE Frown | :(

Anyone has ever encountered this?

Thanks a lot,
Chris Farrugia

Using CodeDOM in .NET

rameshbhojan20-Aug-07 21:01

rameshbhojan

20-Aug-07 21:01

Hi All,
Could anyone please help me out in auto-generating a property in a class in a following format:

public System.Int64 RollNumber
{
get
{
System.Int64 rollNo = (System.Int64 )this["@roll_number"];
return rollNo;
}

}

I am able to generate the property with the return statement and the other stuff, but i am not able to Generate the assignment statement i,e :

System.Int64 rollNo = (System.Int64 )this["@roll_number"];

Please Help.

Thanks,
Ramesh

User Control not feeling the drop down

Sandeep Akhare20-Aug-07 21:01

Sandeep Akhare

20-Aug-07 21:01

I have created a user control that contains All Fields Like Address textbax
City Text box , State drop down ,zip code Textbox
Now State Drop downlist is another user control(different dll) that i am using into that
Now problem i am getting that on first page the drop down is prepopulating the All the list of states but after that is not can anyone tell What might be reasone ?

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

InStr in C#

Imran Khan Pathan20-Aug-07 21:01

Imran Khan Pathan

20-Aug-07 21:01

Hi friends

I want to know Which method is used in c# for InStr method which is used in VB.

VB Sample code

If Not InStr(1, Site.BarredFolders, Path.GetFileName(subdirectory), vbTextCompare) > 0 Then

Thanks In advance

Pathan

---------------------------------------------------

Re: InStr in C#

Michael Sync20-Aug-07 21:22

Michael Sync

20-Aug-07 21:22

Imran Khan Pathan wrote:
InStr

String.IndexOf()??

Actually, there are methods like "str.Substring()" in C#. You have to do some experiments to get the result what you want.

Re: InStr in C#

Christian Graus21-Aug-07 0:12

Christian Graus

21-Aug-07 0:12

Stuff like InStr is best avoided, if you're using VB.NET. Use the same stuff you'd use in C#.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: InStr in C#

Dave Doknjas21-Aug-07 14:02

Dave Doknjas

21-Aug-07 14:02

It's the IndexOf method on the string class.
However, be warned that result is 0-based while the legacy VB method is 1-based.

David Anton
http://www.tangiblesoftwaresolutions.com
Instant C#: VB to C# converter
Instant VB: C# to VB converter
C++ to C# Converter: converts C++ to C#
C++ to VB Converter: converts C++ to VB
C++ to Java Converter: converts C++ to Java
Instant C++: converts C# to C++/CLI and VB to C++/CLI

Auto-Generating a member field in a class using CodeDOM in .NET

rameshbhojan20-Aug-07 20:56

rameshbhojan

20-Aug-07 20:56

Hi All,
I have used CodeDOM in .net to auto-generate C# code, which in essence generates a class file having a class along with its member fields, methods and properties.

However, i don know how to generate the following line of code:

private const string NAME = "CSharp";

Here, i have a generate a CodeMemberField which is a constant string with a private specifier as shown above.
Please send me the sample code which would help me to auto-generate the above line of code.

Otimizing database access in my web application?

Nada Adel20-Aug-07 20:56

Nada Adel

20-Aug-07 20:56

hi,
in my asp.net web application, I insert, update and delete records in an access database..I do that by creating a connection, an adaptor and so on everytime I wanna do any of these things...is there a better way to do these functions without doing this everytime. what's the best way to handle database transactions in my web application in order to make the application faster and optimize its performance??

how to display column wise record in web page

imranafsari20-Aug-07 20:50

imranafsari

20-Aug-07 20:50

Dear all,
I am using asp.net , C# , sql 2005.
I would like to present column wise detail(like gridview present row wise presentation). I manipulate my query to show three column per row (using cursor).

As my query is dynamic I decide at run time which field to show.

Please give me some idea like which web control I use to show column wise record in dynamic case.

Please guide me

thanks

imaran khan

sqldependency

saravanan0520-Aug-07 20:46

saravanan05

20-Aug-07 20:46

Hi friends

what is sqldependency?

regards
saravan

Re: sqldependency

Jay_se20-Aug-07 22:42

Jay_se

20-Aug-07 22:42

SqlDependency ASP.NET[^]

Jey

store image into database

IamAmit20-Aug-07 20:24

IamAmit

20-Aug-07 20:24

I am storing images into database using serialization. while displaying those images into gridview control how to assign them to image button of gridview control?

Re: store image into database

Sandeep Akhare20-Aug-07 20:30

Sandeep Akhare

20-Aug-07 20:30

I think you need to first convert them bitmap or similar to that you can't aasign directly yo any control first convert them stream into some meaning full image type

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Re: store image into database

IamAmit20-Aug-07 20:44

IamAmit

20-Aug-07 20:44

Thanx..do u have any url for dis?

Re: store image into database

Sandeep Akhare20-Aug-07 20:56

Sandeep Akhare

20-Aug-07 20:56

Look into this might be helpfull
http://www.google.co.in/search?hl=en&pwst=1&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=retrieving+image+from+database+asp.net&spell=1[^]

Thanks and Regards
Sandeep

If If you look at what you do not have in life, you don't have anything,
If you look at what you have in life, you have everything... "

Export data from gridview to pdf in ASP .Net

Sumithra Guturi20-Aug-07 20:01

Sumithra Guturi

20-Aug-07 20:01

Hi,
Can any one tell me how to export data from gridview to pdf?
I have tried with the following piece of code:

Response.ClearContent();
Response.AddHeader("content-disposition", "attachment; filename=Report.pdf");
Response.ContentType = "application/pdf";

StringWriter objStrWriter = new StringWriter();
HtmlTextWriter objHtmlTxtWriter = new HtmlTextWriter(objStrWriter);

grdvwReport.RenderControl(objHtmlTxtWriter);
Response.Write(style); // Set the currency columns style
Response.Write(objStrWriter.ToString());
Response.End();

But while opening the pdf iam geeting the follwing message:

AdobeReader could not open 'Report[1].pdf' because it is either not a supported file type or because the file has been damaged.

Please try to help me...
Thanks in advance

Sumithra

Re: Export data from gridview to pdf in ASP .Net

Vasudevan Deepak Kumar20-Aug-07 22:37

Vasudevan Deepak Kumar

20-Aug-07 22:37

http://geekswithblogs.net/vivek/archive/2006/09/26/92316.aspx[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

Re: Export data from gridview to pdf in ASP .Net

Sumithra Guturi21-Aug-07 20:36

Sumithra Guturi

21-Aug-07 20:36

Hi,
I have already tried with that code.But while opening iam getting the error. Is there any other way to convert data from gridview to pdf?

Thanks

i read the html code and html controls into one protected string, i put that server tag into html source. but my problem is i am not able to finding html controls . this is my

Shaik Haneef20-Aug-07 19:24

Shaik Haneef

20-Aug-07 19:24

Hi
i read the html code and html controls into one protected string, i put that server tag into html source. but my problem is i am not able to finding html controls . this is my code

For cnt = 0 To listofobj.Count - 1

If listofobj(cnt).MNU_Imgpath = "" Then
listofobj(cnt).MNU_Imgpath = "Noimg.jpg"
End If
Dim dupchk As Boolean = dupeliminate(listofobj(cnt).MNU_MenuID)

If dupchk = True Then
str &= ""

str &= "" & vbCrLf
str &= " " & vbCrLf
str &= listofobj(cnt).MNU_MenuName
str &= " " & vbCrLf
str &= " " & vbCrLf

End If

str &= "" & vbCrLf

str &= "" & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= "" & vbCrLf
str &= "

" & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " "
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= "

" & vbCrLf
str &= " " & vbCrLf
str &= "

" & vbCrLf
str &= " " & vbCrLf
str &= " " & listofobj(cnt).MNU_ItemName & "
" & vbCrLf
str &= " " & listofobj(cnt).MNU_Desc & "
" & vbCrLf
str &= " Item Availabale From" & listofobj(cnt).MNU_StartTime & " to " & vbCrLf
str &= " " & listofobj(cnt).MNU_EndTime & ""
str &= "

"
str &= " " & vbCrLf
str &= " Price:" & listofobj(cnt).MNU_Price & " " & vbCrLf
str &= "

" & vbCrLf
str &= " Quantity:" & vbCrLf
str &= " " & vbCrLf
str &= " 1" & vbCrLf
str &= " 2" & vbCrLf
str &= " 3" & vbCrLf
str &= " 4" & vbCrLf
str &= " 5" & vbCrLf
str &= " 6" & vbCrLf
str &= " 7" & vbCrLf
str &= " 8" & vbCrLf
str &= " 9" & vbCrLf
str &= " 10" & vbCrLf
str &= " 11" & vbCrLf
str &= " 12" & vbCrLf
str &= " 13" & vbCrLf
str &= " 14" & vbCrLf
str &= " 15" & vbCrLf
str &= " 16" & vbCrLf
str &= " 17" & vbCrLf
str &= " 18" & vbCrLf
str &= " 19" & vbCrLf
str &= " 20" & vbCrLf
str &= " " & vbCrLf
str &= "

" & vbCrLf
str &= "

" & vbCrLf

str &= ""
Next

this string results a grid view format table.

grid view not satisfy my requirement because i want full rows in middle.

the tag is running good showing the items properly. but when i click add the item to cart. i need to be find the html controls which i written in server tag. but i am not able to find it.

dim itemid as new htmlinputcheckbox
itemid = ctype(page.findcotrol("enabled0"),htmlinputcheckbox)

the itemid showing nothing eventhough i have that control....... why ???

is there any other procedure to find the dynamic html control rather than the page.findcontrols...........

example:

pizza
----------------------------------
pizzaimg1 description cost quantity
pizzaimg1 description cost quantity
pizzaimg2 description cost quantity
pizzaimg3 description cost quantity

salad

pizza
----------------------------------
salad1 description cost quantity
salad2 description cost quantity
salad3 description cost quantity

like so on ................

i am assigning the source as array list with generic list of(...)

Hope that any body help me...........

This is haneef.............................................................

This is haneef.............................................................

Re: i read the html code and html controls into one protected string, i put that server tag into html source. but my problem is i am not able to finding html controls . this is my

Christian Graus20-Aug-07 20:38

Christian Graus

20-Aug-07 20:38

This is an absolute mess.

If you don't like how the grid view renders your data, try using a repeater, which allows you to format your data any way you like.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

i read the html code and controls into one protected string, i put that server tag at html source. but my problem is i am not able to finding html controls . this is my code.

Shaik Haneef20-Aug-07 19:19

Shaik Haneef

20-Aug-07 19:19

Hi

i read the html code and html controls into one protected string, i put that server tag into html source. but my problem is i am not able to finding html controls . this is my question

For cnt = 0 To listofobj.Count - 1

If listofobj(cnt).MNU_Imgpath = "" Then
listofobj(cnt).MNU_Imgpath = "Noimg.jpg"
End If
Dim dupchk As Boolean = dupeliminate(listofobj(cnt).MNU_MenuID)

If dupchk = True Then
str &= ""

str &= "" & vbCrLf
str &= " " & vbCrLf
str &= listofobj(cnt).MNU_MenuName
str &= " " & vbCrLf
str &= " " & vbCrLf

End If

str &= "" & vbCrLf

str &= "" & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= "" & vbCrLf
str &= "

" & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " "
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= " " & vbCrLf
str &= "

" & vbCrLf
str &= " " & vbCrLf
str &= "

" & vbCrLf
str &= " " & vbCrLf
str &= " " & listofobj(cnt).MNU_ItemName & "
" & vbCrLf
str &= " " & listofobj(cnt).MNU_Desc & "
" & vbCrLf
str &= " Item Availabale From" & listofobj(cnt).MNU_StartTime & " to " & vbCrLf
str &= " " & listofobj(cnt).MNU_EndTime & ""
str &= "

"
str &= " " & vbCrLf
str &= " Price:" & listofobj(cnt).MNU_Price & " " & vbCrLf
str &= "

" & vbCrLf
str &= " Quantity:" & vbCrLf
str &= " " & vbCrLf
str &= " 1" & vbCrLf
str &= " 2" & vbCrLf
str &= " 3" & vbCrLf
str &= " 4" & vbCrLf
str &= " 5" & vbCrLf
str &= " 6" & vbCrLf
str &= " 7" & vbCrLf
str &= " 8" & vbCrLf
str &= " 9" & vbCrLf
str &= " 10" & vbCrLf
str &= " 11" & vbCrLf
str &= " 12" & vbCrLf
str &= " 13" & vbCrLf
str &= " 14" & vbCrLf
str &= " 15" & vbCrLf
str &= " 16" & vbCrLf
str &= " 17" & vbCrLf
str &= " 18" & vbCrLf
str &= " 19" & vbCrLf
str &= " 20" & vbCrLf
str &= " " & vbCrLf
str &= "

" & vbCrLf
str &= "

" & vbCrLf

str &= ""
Next

this string results a grid view format table.

grid view not satisfy my requirement because i want full rows in middle.

example:

pizza
----------------------------------
pizzaimg1 description cost quantity
pizzaimg1 description cost quantity
pizzaimg2 description cost quantity
pizzaimg3 description cost quantity

salad

pizza
----------------------------------
salad1 description cost quantity
salad2 description cost quantity
salad3 description cost quantity

like so on ................

i am assigning the source as array list with generic list of(...)

Hope that any body help me...........

This is haneef.............................................................

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.