ASP.NET

Re: How to get confirmation from user when clicking on Next button in Wizard Control?

26-Jun-09 20:18

meeram395 wrote:
I don't want to use a javascript for this

Well, you have no choice, unless you want to do a page refresh, to show a new page that asks the user to confirm, then posts back to load whatever page was requested.

Christian Graus

Driven to the arms of OSX by Vista.

"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.

I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp

meeram39526-Jun-09 21:37

meeram395

26-Jun-09 21:37

Thanks Christian.

Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.

Tree View Child Nodes

KhandelwalA26-Jun-09 19:25

KhandelwalA

26-Jun-09 19:25

I am creating Tree view from database.....but its returning only one Parent Node and one Child nodee.......why......this is my code:-

Dim db As Database = DatabaseFactory.CreateDatabase("See2Buy")
Dim cmd As String = "Select Cat.CategoryID, Cat.CategoryName,SubCat1.SubCat1ID,SubCat1.SubCategoryName From Cat INNER JOIN SubCat1 ON Cat.CategoryID=SubCat1.CategoryID ORDER BY Cat.CategoryID"
Dim rdr As IDataReader = db.ExecuteReader(CommandType.Text, cmd)
While rdr.Read
Dim cat As New TreeNode
cat.Text = rdr("CategoryName").ToString()
cat.Value = rdr("CategoryID").ToString()
TreeView1.Nodes.Add(cat)
TreeView1.Nodes.Add(cat)
While rdr.Read
Dim cat1 As New TreeNode
cat1.Text = rdr("SubCategoryName").ToString()
cat1.Value = rdr("SubCat1ID").ToString()
cat.ChildNodes.Add(cat1)
End While
End While

Re: Tree View Child Nodes

Christian Graus26-Jun-09 20:20

Problem in storing image in database

26-Jun-09 20:20

your SQL looks to me like it will always return one child for each parent.

suzzain26-Jun-09 19:17

suzzain

26-Jun-09 19:17

Hi all,

I am saving an image in database in the image field but the image is getting saved in hexadecimal form inspite of the field defined as image type. When im trying to show the image through asp.net code im getting an error.

Please help me how i can store the image in database and show it.

Re: Problem in storing image in database

KhandelwalA26-Jun-09 19:27

KhandelwalA

26-Jun-09 19:27

There are two ways to store image in database......First one is to Convert the Image in Binary and store it in Database..........Second way is to store image physically at particular folder location and store Path of that image in Database

Re: Problem in storing image in database

K030626-Jun-09 19:31

K0306

26-Jun-09 19:31

try this link
insert and retrieve image using sql[^][^]

Re: Problem in storing image in database

r a m e s h26-Jun-09 19:39

How can I connet Mysql with Asp.net

26-Jun-09 19:39

Image data type will store the content of an image file in binary format. It will not show you the visual representation of image that you stored in it when you see a record in SQL server.

Post the error message so that someone can help you to get the solution.

Member 426027026-Jun-09 18:33

Member 4260270

26-Jun-09 18:33

Hi,

This is my code for connecting Mysql with Asp.net.But i get the following error

"ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

My code is as follows:

Imports System.Data.Odbc
Imports System.Data.OleDb
Imports System.Data

Dim sConString As String = "DRIVER={MySQL Server 5.1}; SERVER=localhost;DATABASE=test;UID=root;PASSWORD=denny"

Dim oConnection As OdbcConnection = New OdbcConnection(sConString)
Dim sSQL As String = "SELECT * FROM personal"
Dim oDataAdapter As OdbcDataAdapter = New OdbcDataAdapter(sSQL, oConnection)
Dim oDataSet As DataSet = New DataSet()
oDataAdapter.Fill(oDataSet)
GridView1.DataSource = oDataSet
GridView1.DataBind()

Thanks
Denny

r a m e s h26-Jun-09 18:54

26-Jun-09 18:54

If you are running this code from your PC, Check whether you have installed ODBC Driver for MySQL.

Control Panel->Administrative Tools->Data Source(ODBC)->Driver Tab

r a m e s h26-Jun-09 18:56

26-Jun-09 18:56

Instead of using OleDb, You can also use MySQL's Managed ADO.Net provider [^]

Member 426027026-Jun-09 19:16

Member 4260270

26-Jun-09 19:16

From where can I get ODBC Driver for MySQL

r a m e s h26-Jun-09 19:29

Specified argument out of the range -nested Gridview

26-Jun-09 19:29

From here[^]

gtjr92126-Jun-09 17:30

gtjr921

26-Jun-09 17:30

I have a gridview(Gvpatientnm) that has another gridview embedded in it (gviewvisitdetailsinfo)

I have a sub that on the selected index changed that open a detailsview based on the gviewvisitdetailsinfo selected value in a modal pop up window.
I had this working, but it is erractic. I keep getting.
Specified argument was out of the range of valid values.
Parameter name: index

This all happens on selected indexchanged for the gviewvisitdetails grid

here is my code

1. Protected Sub gvVisits_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs)
 2.         Dim row As GridViewRow
 3.         For Each row In gvPatientsNM.Rows
 4.             Dim gvVisit As GridView = CType(row.FindControl("gviewVisitDetailInfo"), GridView)
 5.
 6.
 7.
 8.             Dim varVisitid = gvVisit.SelectedValue
 9.             odsVisitsEdit.SelectParameters("VisitID").DefaultValue = varVisitid
10.
11.
12.         Next
13.
14.         dviewVisitsEdit.DataBind()
15.         dviewVisitsEdit.ChangeMode(DetailsViewMode.Edit)
16.         ModalpopupVisits.Show()
17.     End Sub

Re: Specified argument out of the range -nested Gridview

Christian Graus26-Jun-09 17:44

Re: Specified argument out of the range -nested Gridview

26-Jun-09 17:44

Which line ? The error means what it says, you should at a minimum always check a value before using it as an index, to make sure it's within the correct range.

Member 1832081 wrote:
odsVisitsEdit.SelectParameters("VisitID").DefaultValue = varVisitid

I'd say either varVisitid is not a right value, or VisitID is not found. You should break this code down and write it so it is safe. Then try to work out why it's failing.

gtjr92127-Jun-09 4:05

gtjr921

27-Jun-09 4:05

it's telling me it for this line

<pre> dviewVisitsEdit.DataBind()

Even if I take that out I still get it.

I have narrowed down the issue a little further.
If I only have one row in my top level Gridview - gvpatientname it works fine.
If I have 2 rows in the gvpatientnm grid Then the selected row for the embedded gridview -gvvisitdetails
stays selected if I change from one patientname row to another. So the gvvisit could have two rows selected under two patients.

Let me try to illustrate

gvpatientnm

PatID Name
1 Joe Jones
gvvisitsDetails
PatID VisitID
1 1234
1 6783
then for another patient the gvpatiennm gridview and gvvisit gridview are repeated
gvpatientnm
2 Mike Johnson
gvvisitsDetails
PatID visitid
2 4747

Here's a link to a screen shot of the grid
<GridView Pics (opens in new window)

Notice how both edit buttons are able to be selected, this causes a problem when I try to send the selected value to
my detailsview - dvvisitedit.

I am not sure how the best way to handles this is??
Help is appreciated.
Thanks

Re: Specified argument out of the range -nested Gridview

gtjr92130-Jun-09 2:42

gtjr921

30-Jun-09 2:42

Got it to work

Dim gv As GridView = DirectCast(sender, GridView)
 odsVisitsEdit.SelectParameters("VisitID").DefaultValue = gv.SelectedValue
 dviewVisitsEdit.DataBind()
 dviewVisitsEdit.ChangeMode(DetailsViewMode.Edit)
 ModalpopupVisits.Show()

Tree View

KhandelwalA26-Jun-09 8:25

KhandelwalA

26-Jun-09 8:25

I want to create Tree through Database.........For Root nodes i wrote this code....can anybody guide me how to make child nodes.

i hav category(cat_id,cat_name),
sub category(sub_cat_id,cat_id,sub_cat_name) tables
under category node i have to fill subcategory names as child node

con.Open()
cmd = New SqlCommand("select cat_id,cat_name from tbl_category order by cat_name", con)
dr = cmd.ExecuteReader()
While dr.Read()
cat = New TreeNode()
cat.Text = dr("cat_name").ToString
cat.Value = dr("cat_id").ToString
TreeView2.Nodes.Add(cat)
End While

dr.Close()
con.Close()

Re: Tree View

Manas Bhardwaj26-Jun-09 8:33

Manas Bhardwaj

26-Jun-09 8:33

Use this query to get the results

SELECT 
    Category.cat_id, Category.cat_name, SubCategory.Sub_cat_id, SubCategory.sub_cat_name
FROM 
    Category
INNER JOIN SubCategory ON
    Category.cat_id = SubCategory.cat_id
ORDER BY
    Category.cat_id

Now, loop through the results and while the catid is same add the subids as child nodes Rose | [Rose]

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Can some one help me answer this question?

Slow Learner26-Jun-09 7:43

Slow Learner

26-Jun-09 7:43

2).An application using cookie authentication was working fine on another server. When moved to a new server cookie authentication is not working correctly.Which one of the following is the likely explantion of the above problem?

a).The new IIS server is not configured to allow anonymous access.
b).passport authentication is not correctly configured
c).The users are not correctly entering their password
d).The IP address of the new server does not match the prior server IP address.
e).SSL is not properly configured

Thanks,

L

Re: Can some one help me answer this question?

Christian Graus26-Jun-09 9:19

Re: Can some one help me answer this question?

26-Jun-09 9:19

Have you had your job interview yet ? Some of these options are ridiculous, and if you don't know the answer, you don't deserve the job. Can you tell us which ones can't possibily be the issue, and why ?

Slow Learner26-Jun-09 9:27

Slow Learner

26-Jun-09 9:27

I am thinking of either it could a or e. I found this some online site.

Re: Can some one help me answer this question?

Christian Graus26-Jun-09 9:33