the command is not available because no document is open - ASP.NET Discussion Boards

Re: how to publish website through IIS

hi_everybody25-Feb-10 19:49

hi_everybody

25-Feb-10 19:49

thanks a lot its helpful to me thanks

No results.. please try again message

DaithiBoo25-Feb-10 1:02

DaithiBoo

25-Feb-10 1:02

Hi there.. Smile | :)

im workin on a website at the moment in asp.net, using vb.net, in the visual studios 2008 IDE! i just wish to add an extra feature and hopefully someone out there might be able to help.
I have a button that reads the values of 5 radio buttons in a radiobutton list, then queries the database, returning results based on the values selected. If no value is returned i wish to display a message saying "No Results this time, please search again" or something to that effect. Im not sure how to do this. here is the code i have behind the button.. Please advise.

Protected Sub btnSuggest_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnSuggest.Click

Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim dr As SqlDataReader
Dim varBatteryLifeQ As String = ""
Dim varMemoryQ As String = ""
Dim varRam As String = ""
Dim varScreenSize As String = ""
Dim varWebcam As String = ""

myConnection = New SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True")

myConnection.Open()

varBatteryLifeQ = RadioButtonList1.SelectedValue.ToString
varMemoryQ = RadioButtonList2.SelectedValue.ToString
varRam = RadioButtonList3.SelectedValue.ToString
varScreenSize = RadioButtonList4.SelectedValue.ToString
varWebcam = RadioButtonList5.SelectedValue.ToString

myCommand = New SqlCommand("Select * From LPU400 Where BatteryLife = '" + varBatteryLifeQ + "' AND Memory = '" + varMemoryQ + "' AND RAM ='" + varRam + "' AND ScreenSize ='" + varScreenSize + "' AND Webcam ='" + varWebcam + "'", myConnection)
SqlDataSource2.SelectCommand = "Select * From LPU400 Where BatteryLife = '" + varBatteryLifeQ + "' AND Memory = '" + varMemoryQ + "' AND RAMQ ='" + varRam + "' AND ScreenSize ='" + varScreenSize + "' AND Webcam ='" + varWebcam + "'"
SqlDataSource2.DataBind()

dr = myCommand.ExecuteReader()

While dr.Read()

End While

dr.Close()

myConnection.Close()

End Sub

Thanks in advance,

Daithi

Re: No results.. please try again message

Dinesh Mani25-Feb-10 1:20

Dinesh Mani

25-Feb-10 1:20

Before you proceed with dr.Read() check if dr.HasRows. If yes proceed to read, else put "No Results this time, please search again" in a label or some other place holder.

HTH!

Re: No results.. please try again message

DaithiBoo25-Feb-10 1:47

DaithiBoo

25-Feb-10 1:47

ya that did it! thanks a million for your help! very much appreciated!

Dynamic Report Designing

Kashif Sabir25-Feb-10 0:43

Kashif Sabir

25-Feb-10 0:43

Hi,
I want to develop an application using asp.net in which user can create reports by dropping labels and database fields and move and place them any where they like in other words design report as per there requirement (during runtime) and then save that format and call that report. Is there any possiblity to make such application.
waiting for your response.

Re: Dynamic Report Designing

i gr825-Feb-10 19:31

i gr8

25-Feb-10 19:31

Yes its possible, but u need to predefine the Report format(if u want different types of format) or else fix the format(controls that are dropped/Selected by user will be placed in left to right format only) and u can achieve the user generated report.

i have done this in one of projects

need help for writting javascript for transferring data from one system to another

hi_everybody25-Feb-10 0:28

hi_everybody

25-Feb-10 0:28

hi Friends,
my system is related to travels.In that, i want to create an two applications one is on in my system and another is on Client side say "ABC travels".When any user logon to that site, i have to check that user info with info which is stored in my system by using these two applications.For that "ABC travels" my system has some permission i.e. i only want to give permission for specific 10 buses,20 cars bookings to that client.so when any user make any booking from site of "ABC travels". first i have to check the userinfo as specified earlier then i want to send the data i.e. according permissions to their site,so that user can book any bus or car only from that 10 buses and 20 cars.If user book any bus.then the application which is in client side should send that booking information to my system.and my system will store that info in database.
this is flow of my system, i am new so i didn't get how actualy i can do it.so will you please help me....
i don't know how can i transfer data from my system to client and form client to my system....
plzzz help me plzz
thanks

the command is not available because no document is open

vimalkumarsinghal24-Feb-10 23:06

vimalkumarsinghal

24-Feb-10 23:06

hi guys

i m using asp.net an C#

im trying to convert .docx to html

when i use my machine documents open and also easily converted to html,,my machine have (xp sp2,visual studio2008,MS Office 2007)

when i go for client pc when i click convert button i m getting error like this

"the command is not available because no document is open"

Microsoft.Office.Interop.Word.ApplicationClass wordApplication = new ApplicationClass();
                    object o_nullobject = System.Reflection.Missing.Value;
                    String strfiletoupload = @"C:\inetpub\wwwroot\wss\VirtualDirectories\12122\uploaded\template\DeveloperEmail.docx";
                    object o_filePath = strfiletoupload;
                    Microsoft.Office.Interop.Word.Document doc = wordApplication.Documents.Open(ref o_filePath,
                                  ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject,
                                 ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject,
                                ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject);
                    object o_newfilename = @"C:\inetpub\wwwroot\wss\VirtualDirectories\12122\uploaded\template\NewsletterEmail.html";
                    object o_format = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatFilteredHTML;
                    //object o_format = Microsoft.Office.Interop.Word.WdSaveFormat.wdFormatHTML;
                    object o_encoding = Microsoft.Office.Core.MsoEncoding.msoEncodingUTF8;
                    object o_endings = Microsoft.Office.Interop.Word.WdLineEndingType.wdCRLF;
                    //Microsoft.Office.Interop.Word.wd
                    object o_BiDiMark = true;

                    wordApplication.ActiveDocument.SaveAs(ref o_newfilename, ref o_format, ref o_nullobject,
                            ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_nullobject, ref o_BiDiMark,
                            ref o_BiDiMark,
                        ref o_nullobject, ref o_nullobject, ref o_encoding, ref o_nullobject,
                            ref o_nullobject, ref o_endings, ref o_BiDiMark);
                    doc.Close(ref o_nullobject, ref o_nullobject, ref o_nullobject);

                    wordApplication.Quit(ref o_nullobject, ref o_nullobject, ref o_nullobject);
                    System.Runtime.InteropServices.Marshal.ReleaseComObject(wordApplication);

Please help me to fix this

regard
vimal

Re: the command is not available because no document is open

Nasri871-Mar-10 21:39

Nasri87

1-Mar-10 21:39

Hi vimal,

try these links, mayb helpful for u.

http://msdn.microsoft.com/en-us/magazine/cc163526.aspx.[^]

HTML to WordML[^]

How do we convert a data from database into XMLfile using asp.net with vb.net

vbmadhavi24-Feb-10 23:05

vbmadhavi

24-Feb-10 23:05

hello all

How do we convert a data from database into XMLfile using asp.net with vb.net

i dont now such idea plzz send code also.

Re: How do we convert a data from database into XMLfile using asp.net with vb.net

Nuri Ismail25-Feb-10 0:18

Nuri Ismail

25-Feb-10 0:18

You can use DataSet[^] to load your database and after that you can call DataSet.WriteXml[^] method.

vbmadhavi wrote:
plzz send code also.

Writing your code is your responsibility. Just search for DataSet tutorials, you will find lots of information. Smile | :)

I hope this helps. Smile | :)

Re: How do we convert a data from database into XMLfile using asp.net with vb.net

Sanjay Jaiswal 123456725-Feb-10 0:32

Sanjay Jaiswal 1234567

25-Feb-10 0:32

use Query From database Which gives to XML String.
For Example:
Select * from emp "Emplyee" FOR XML Auto

Which gives out put like

<Emplyee empid="11" ename="rajan" sal="1.200000000000000e+004" ephone="5654645" eAddress="baneshwor" />
<Emplyee empid="12" ename="pravakar" sal="2.500000000000000e+004" ephone="5654645" eAddress="shantinangar" />
<Emplyee empid="13" ename="nilu" sal="2.500000000000000e+004" ephone="5654645" eAddress="ghattekkulo" />
<Emplyee empid="14" ename="shekhar" sal="2.500000000000000e+004" ephone="5654645" eAddress="ekantakuna" />
<Emplyee empid="15" ename="sunil" sal="2.500000000000000e+004" ephone="5654645" eAddress="budanilakantha" />
<Emplyee empid="16" ename="Nilubhai" sal="2.000000000000000e+003" ephone="123456" eAddress="Kathmandu" />

Re: How do we convert a data from database into XMLfile using asp.net with vb.net

Nuri Ismail25-Feb-10 0:41

Nuri Ismail

25-Feb-10 0:41

You probably have to post this message to OP, too.
Your suggestion is good in case we want to save only data as XML.
But if we want to save entire database, including schema information except data, then DataSet.WriteXml method is very handy. Smile | :)

Regards

Onclick Event

Paulraj G24-Feb-10 22:54

Paulraj G

24-Feb-10 22:54

Hi...

I am newbie to asp.

my code is,

<asp:Button ID="LOGIN" Text="Submit"   Height = "25px" Width = "78px" 
            runat="server" onclick="LOGIN_Click" ></asp:Button> 
            <br />
            
            <%if (Login_Result == "1")
              {
                  
              }
              else
              {
                  Response.Write(Login_Result);
              } %>
            </p>

when i click login button it will check in the database by c# code.
if its true means Login_Result will return "1". Otherwise it will return "0".
if Login_Result is "1", I have call call a new form main.aspx. How to do this?

Help me...

G.Paulraj

Re: Onclick Event

R. Giskard Reventlov24-Feb-10 23:24

R. Giskard Reventlov

24-Feb-10 23:24

Response.Redirect("main.aspx");

is one way: there are others.

Tychotics: take us back to the moon

"Life, for ever dying to be born afresh, for ever young and eager, will presently stand upon this earth as upon a footstool, and stretch out its realm amidst the stars."
H. G. Wells

Re: Onclick Event

Lokesh Zende25-Feb-10 4:04

Lokesh Zende

25-Feb-10 4:04

what about code behind?
Is it in c# or vb?

If its c# , then
why don't you write your code on the on click event?
Big Grin | :-D

Re: Onclick Event

Not Active25-Feb-10 4:12

Not Active

25-Feb-10 4:12

You should check the original post

Paulraj G wrote:
it will check in the database by c# code.

LokeshZende wrote:
If its c# , then
why don't you write your code on the on click event?

So you can't use code-behind with VB.NET?

You have done nothing to answer the OPs question.

I know the language. I've read a book. - _Madmatt

Cannot get checkbox element in Datagrid using javascript in FF

lahari_padigala24-Feb-10 21:09

lahari_padigala

24-Feb-10 21:09

I have a checkbox in a datagrid and when i check the items and press addbutton i need to add all the checked rows value into hidden field.the add button calls the function readData() on client side.

the code was working fine with IE but it was not woking with mozilla

function ReadData() {

var grdContacts = document.getElementById('grdContacts');

var hiddenContacts = document.getElementById('hiddenContacts');

var rowCount = grdContacts.rows.length;

if(rowCount > 1)

{

var count =1;

for(; count < rowcount ; count++)

{

if(grdContacts.rows[count].cells[0].childNodes[0].childNodes[0].checked == true)

{ hiddenContacts.value += grdContacts.rows[count].cells[2].innerText + ";"; }

}

}

Re: Cannot get checkbox element in Datagrid using javascript in FF

Chetan Patel24-Feb-10 22:38

Chetan Patel

24-Feb-10 22:38

You can try with innerHTML

It should work in all the browser

Best Regards,
Chetan Patel

Re: Cannot get checkbox element in Datagrid using javascript in FF

lahari_padigala25-Feb-10 1:13

lahari_padigala

25-Feb-10 1:13

I need to first find my check box and if the check box is checked then i need to get the InnerText.

I got the solution for the above.
Modified the function as below.

function ReadData()
{
var grdContacts = document.getElementById('grdContacts');
var hiddenContacts = document.getElementById('hiddenContacts');
var rowCount = grdContacts.rows.length;
if(rowCount > 1)
{
var browserName=navigator.appName;
for(var count =1; count

Not loading Images in login page web application

myms.net24-Feb-10 21:03

myms.net

24-Feb-10 21:03

I have developed one internal web application having login credentials page with images.
main problem is that, the images are not loaded in login page. after login, in other page the same images are loading. i used I.E 8.and Firefox3. in both browsers not loaded the images.

we are using skinid.
below code is written like this

<asp:image runat="server" imageurl="~/App_Themes/Default/Images/myimage_beta.png" skinid="HeaderImage">;

Thanks in advance..

Re: Not loading Images in login page web application

anushh24-Feb-10 22:35

anushh

24-Feb-10 22:35

If u want to load before login into the application means, first check the web.config file has the '<deny>' property. To resolve this u must include <allow> property for the corresponding page(that is, if u load the images only after login means the .css file load successfully only after getting the credentials ). Try this! It may useful!

Re: Not loading Images in login page web application

myms.net24-Feb-10 23:06

myms.net

24-Feb-10 23:06

problem has resolved......
I have changed authentication security for integrated windows authentication check box checked in IIS settings

Thanks for your reply.

Re: Not loading Images in login page web application

Ravindra Nidhonkar24-Feb-10 23:07

Ravindra Nidhonkar

24-Feb-10 23:07

It might be you have used Forms Authentication in your application.
Put another Web.config file in your Images folder and remove the Authentication from that file.

how to insert the data into xml file using asp.net with vb.net

vbmadhavi24-Feb-10 20:18

vbmadhavi

24-Feb-10 20:18

hello everybody.

i want to insert the data into xmlfile.how it possible.
i developed code for this .but i dont know whether it is correct or not.

Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
' Create xml dom
Dim XMLDom As New XmlDocument()
'this xml file is already i created.
XMLDom.Load("D:\XMLFILE1.xml")
'Selecting the main node
Dim newXMLNode As XmlNode = XMLDom.SelectSingleNode("persons")
'''''''get the node where i want to insert the data
Dim childNode As XmlNode = XMLDom.CreateNode(XmlNodeType.Element, "p", "")
''''''''In the below step "p" is my node name and "sree" is my data to insert
Dim newAttribute As XmlAttribute = XMLDom.CreateAttribute("p", "sree", "")
childNode.Attributes.Append(newAttribute)
newXMLNode.AppendChild(childNode)
end sub
when i run this code error occured i.e

Object reference not set to an instance of an object.
this error is occured in newXMLNode.AppendChild(childNode)

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