Jump to content

sansat6699

Members
  • Posts

    38
  • Joined

  • Last visited

sansat6699's Achievements

Newbie

Newbie (1/7)

0

Reputation

  1. thanks guys i try out and let u know
  2. i am creating application in c# .net 3.5 i want create file like giveni am having very less knowledge in xml please help me <ENVELOPE><HEADER><TALLYREQUEST>Import Data</TALLYREQUEST></HEADER><BODY><IMPORTDATA><REQUESTDESC><REPORTNAME>Vouchers</REPORTNAME><STATICVARIABLES><SVCURRENTCOMPANY>As Enterprise</SVCURRENTCOMPANY></STATICVARIABLES></REQUESTDESC><REQUESTDATA><TALLYMESSAGE xmlns:UDF="TallyUDF"> <VOUCHER REMOTEID="ecc576b5-9209-40e9-9673-590cdf81b646-00000037" VCHTYPE="Sales" ACTION="Create"> <ISOPTIONAL>No</ISOPTIONAL> <USEFORGAINLOSS>No</USEFORGAINLOSS> <USEFORCOMPOUND>No</USEFORCOMPOUND> <VOUCHERTYPENAME>Sales</VOUCHERTYPENAME> <DATE>20090404</DATE> <EFFECTIVEDATE>20090404</EFFECTIVEDATE> <ISCANCELLED>No</ISCANCELLED> <USETRACKINGNUMBER>No</USETRACKINGNUMBER> <ISPOSTDATED>No</ISPOSTDATED> <ISINVOICE>Yes</ISINVOICE> <DIFFACTUALQTY>No</DIFFACTUALQTY> <VOUCHERNUMBER>1</VOUCHERNUMBER> <PARTYNAME>Gl Construction</PARTYNAME> <PARTYLEDGERNAME>Gl Construction</PARTYLEDGERNAME> <ASPAYSLIP>No</ASPAYSLIP> <GUID>ecc576b5-9209-40e9-9673-590cdf81b646-00000037</GUID> <ALTERID> 58</ALTERID> <ALLLEDGERENTRIES.LIST> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISDEEMEDPOSITIVE>Yes</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <LEDGERNAME>Gl Construction</LEDGERNAME> <AMOUNT>-2300.00</AMOUNT> <BILLALLOCATIONS.LIST> <NAME>1</NAME> <BILLTYPE>New Ref</BILLTYPE> <BILLCREDITPERIOD/> <AMOUNT>-2300.00</AMOUNT> </BILLALLOCATIONS.LIST> </ALLLEDGERENTRIES.LIST> <ALLLEDGERENTRIES.LIST> <REMOVEZEROENTRIES>No</REMOVEZEROENTRIES> <ISDEEMEDPOSITIVE>No</ISDEEMEDPOSITIVE> <LEDGERFROMITEM>No</LEDGERFROMITEM> <LEDGERNAME>Sale</LEDGERNAME> <AMOUNT>2300.00</AMOUNT> </ALLLEDGERENTRIES.LIST> <UDF:BUYERNAME.LIST DESC="`BUYERNAME`" ISLIST="YES"> <UDF:BUYERNAME DESC="`BUYERNAME`">Gl Construction</UDF:BUYERNAME> </UDF:BUYERNAME.LIST> <UDF:DATETIMEOFINVOICE.LIST DESC="`DATETIMEOFINVOICE`" ISLIST="YES"> <UDF:DATETIMEOFINVOICE DESC="`DATETIMEOFINVOICE`">4-Apr-2009 at 18:09</UDF:DATETIMEOFINVOICE> </UDF:DATETIMEOFINVOICE.LIST> <UDF:DATETIMEOFREMOVAL.LIST DESC="`DATETIMEOFREMOVAL`" ISLIST="YES"> <UDF:DATETIMEOFREMOVAL DESC="`DATETIMEOFREMOVAL`">4-Apr-2009 at 18:09</UDF:DATETIMEOFREMOVAL> </UDF:DATETIMEOFREMOVAL.LIST> <UDF:BASEPARTYNAME.LIST DESC="`BASEPARTYNAME`" ISLIST="YES"> <UDF:BASEPARTYNAME DESC="`BASEPARTYNAME`">Gl Construction</UDF:BASEPARTYNAME> </UDF:BASEPARTYNAME.LIST> </VOUCHER></TALLYMESSAGE></REQUESTDATA></IMPORTDATA></BODY></ENVELOPE> thank you
  3. hi i have 2 integer columns in my table one is set to identity column with auto increment , i want my other column also auto increment without identity attribute, please suggest me solutionthank you,
  4. i have my connection string placed in appsetting tag in web.config file and i am accesing it in class as now problem is that is it ok that if i created instance of class on another pagae like then i am accessing that instance with connection created in itlike it's a multiuser application so it is okey to open connection from class in page , or recomend me better approch connection with sqlserver
  5. i have 2 forms, on form named "A" i making some selection and click on button present on form A which opens form named "B", but i want to do it without post back and pass selected parameters on form A to form B all without postback. i knew parameters can be passed with querystring and postback can be avoided using onlclientclick function using java script all this need to be done in c# codebehind file but i am not getting success _btnallhrpt.Attributes.Add("onclick","window.open('~/sales/allchrpt.aspx?fdt='" +PickerFrom.SelectedDate.ToString ()+ "'&tdt='"+PickerTo.SelectedDate.ToString()+"','','toolbar=no');return false;"); this is what i am trying in page A's page load event but it is not working, plese help me.
  6. thanks for being so plesent
  7. i recently created c#.net web application in vs2005 environment using membership control provided by vs 05 ,first i uploded my site to ftp a/c then generated sql script from enterprise manager of my local database and run script on remote database using sql query analyzer database created , i try to run application it give me error on login page that 'dbo.aspnet_CheckSchemaVersion' stored procedure have not permission to executethen i learned that dbo is admin then i created stored procedures with my user name ('abc'), then i followed same and change stored procedures ownership to my username ('abc') than again i try to run my application it give error that but , i serched a lot but i not find a solution on that please help me in solving it
  8. ok can u tell me how to validate ddl on selected value rather than text present in ddl using initial value property.ie i have ddl bounded to databse text for display in ddl and value bounded which integer value to every item in ddl.
  9. i have a drop down list i want to validate it, it is bounded to database as text field for display and integer value for coding i.e selected items value.so i want to validate dropdownlist on its selected items valiue rather than text present in ddl for make sure that user selected some item.i know about InitialValue propery but it only checks for text in dropdpwnlist so what happening is if someon type a text and not seleced item in ddl it gets valideted so i want to implement validation on its seleceted items value using standrd asp.ent2.0 validation controlsplease help
  10. hii have code like given below. i am using asp.net2.0(c#), sqlserver 2000 public void loadmunitcombo(ComboBox cmbunit,string sFilter) { DataSet ds1 = new DataSet(); DataTable munit1 = new DataTable("munit1"); string conStr = ConfigurationSettings.AppSettings["asccon"]; System.Data.SqlClient.SqlConnection dbCon = new System.Data.SqlClient.SqlConnection(conStr); System.Data.SqlClient.SqlConnection dbCon1 = new System.Data.SqlClient.SqlConnection(conStr); dbCon.Open(); SqlDataReader dr; SqlCommand cmd = new SqlCommand("select * from MUTran where M_ID='" + sFilter + "'",dbCon); dr = cmd.ExecuteReader(); while (dr.Read()) { string str1; dbCon1.Open(); SqlDataReader dr1; SqlCommand cmd1 = new SqlCommand("select * from UM where U_Id="+dr.GetInt32(2)+"",dbCon1); dr1 = cmd1.ExecuteReader(); while (dr1.Read()) { //here i want to insert data in to datatable one by one and after completion of while loop i want to insert table into dataset ListItem li = new ListItem(); li.Text = dr1.GetString(1); li.Value = dr1.GetInt32(0).ToString(); cmbunit.Items.Add(new ComboBoxItem(li.Text.ToString())); } dr1.Close(); dbCon1.Close();//here i want to create dataset fro created table above } dr.Close(); dbCon1.Close(); } so please help me in creating datatable and then insert datatable into dataset. only this kind of logic i know for getting required values from second table depend on selected items in combobox. any body havind doffrent logic fro this kind of queries involving dataset will be healpfullthank you,
  11. i am having 2 sql servers one is web sql server server and other server is my local sql server. i am making web application through which i want to connect both sql servers at a time and by selecting data from web server i want to insert it into my local sql server both having same database on which i want to work , i want to know how it can be done my idea as follows in web.config i specify 2 connection string and by selecting data from websql server database table i going to store it in dataset and then i return dataset to another function which connects to local sqlserver database.but database records are much large. can any body guide me .i am going to place my web application on local server (C# asp.net 2.0) .thank you,
  12. hii buyed hosting for my site , i am using sqlserver 2000 as backend. hosting compony allow to connect to my database through queryanalyzer not from enterprise manager.hosting compony charge me for taking database backup on there server. so i want to know how can i take databse backup from remote sql server 2000 to my local sql server 2000,any tool process by which it is possible to take databse backup at my own computers sql server 2000.thankyou;
×
×
  • Create New...