ASP.NET

Convert CrystalReport to Sqlserver Reporting server

26-Jun-09 23:39

his issue is he can't read, so he keeps asking until someone reads his mind.

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

ptvce26-Jun-09 20:05

ptvce

26-Jun-09 20:05

can anybody help me about this subject?plz

Re: Convert CrystalReport to Sqlserver Reporting server

r a m e s h27-Jun-09 0:28

Hardware Cofiguration and Software details

27-Jun-09 0:28

I found some information in the following links:

http://charliem.wordpress.com/2007/03/21/convert-crystal-reports-to-sql-reporting-services/[^]

http://blogs.technet.com/mat_stephen/archive/2005/02/01/convert-crystal-reports-to-sql-server-reporting-services.aspx[^]

raushan_926-Jun-09 19:55

raushan_9

26-Jun-09 19:55

Hello Friend,
actually i am developing a Intranet application.i want to get all system of Hardware configuration & software details using WMI through Client Ip address. actually i got all Ip Address of system through Ping.and i want to know Hardware Configuration of system & Installed Software Details according to IP Address.

Thanks & Regards
raushan

Re: Hardware Cofiguration and Software details

Christian Graus26-Jun-09 20:16

Re: Hardware Cofiguration and Software details

26-Jun-09 20:16

This is not really an ASP.NET question. ASP.NET could not do this, this will only work because you're on an intranet and can do it through your network, in theory.

raushan_926-Jun-09 20:28

raushan_9

26-Jun-09 20:28

Ye, you r right, then how i will get Hardware & Software Details through network. Because i have need only in my organization network.
Please give some idea to do in Intranet....

Thanks & Regards
raushan

Re: Hardware Cofiguration and Software details

Christian Graus26-Jun-09 21:01

Set Focus from html textbox to html listbox.....

26-Jun-09 21:01

I'm suggesting this is the wrong forum, and you should ask in the C# forum. I don't actually know the answer, I'm telling you the best place to find it.

dayakar_dn26-Jun-09 19:54

dayakar_dn

26-Jun-09 19:54

Hi,

I have html textbox and html listbox. If i type a letter in textbox corresponding names are populated to listbox.
After that i need to set the focus to my listbox when i press downarrow.

I am trying to implement this using onkeyup event by writing the follwing code:
if(key == 40)
{
//document.getElementById("ddlForResult").options(0).focus();
document.getElementById("ddlForResult").options[0].selected = true;
// var myControl = document.getElementById("ddlForResult");
// myControl.focus();
// myControl.select();
//document.getElementById("ddlForResult").selectedIndex = 0;
}

But the focus is not set into first element of listbox.

I dont know where i did a mistake, If anybody knows the solution for this please let me know....

Re: Set Focus from html textbox to html listbox.....

Christian Graus26-Jun-09 20:17

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

26-Jun-09 20:17

dayakar_dn wrote:
ddlForResult

Is this the client side name for the control ? If it's a server control, then use the ClientID property to get the client side id.

meeram39526-Jun-09 19:54

meeram395

26-Jun-09 19:54

In my page, I have a wizard control. Inside a Wizard control, there is only one textbox which checks for an unique document number. When the user types a document number in the textbox, I am checking whether it already exists in the database. if exists, I want to show a warning saying that this will be a revision of existing document.

User can either accept or reject this. How can I do this confirmation on the click on Next button of Wizard Control? I don't want to use a javascript for this. Is there any other way which i can achieve this? Please help.

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

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

Christian Graus26-Jun-09 20:18

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.

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