Maideen

Hi I am new in PHP. I have used dropdown to bind with my sql data. It is ok But I could not insert data into table only from dropdown. Other controls like text can be inserted. I have given code below. Pls advise me. Maideen <?php require_once '../inc/header.php'; ?> …

HI I need to send data from my mssql table to my client by email... Currently I can send one by one items.(more than 200 items) Private Sub SendEmail() Dim body As String = Me.PopulateBody Me.SendHtmlFormattedEmail(Session("email"), ".", body) Session.Remove("email") End Sub Private Sub SendHtmlFormattedEmail(ByVal recepientEmail As String, ByVal subject As …

Hi Sir I have a problem in passing value from Popop to main page I am using Master page and aspx page From main page, i can open popup windows and populate data in gridview. I am selecting date and capture the valeu in TextBox. When I click the button …

Hi I developed the asp.net project for trading. Working Fine But We facing Printing Delivery Order/ Report. Currently very curcial issue is print statement. Now we select Account Number of customer and generate Delivery Order and export into PDF then we print this. Our client has about 500 customer. It …

Hi Pls advice me the following calculation in stored Procedure my scenario is packing the magazine Example: Order = 6042 copies. 6042 have to be packed by 20 each. so 302 bundle. balance 2 copies. If I divide 6042 /20 Result is 302.10 . How can store 302 and 2 …

Hi. I am Sorry that I don't know how to ask question for my Scenario. Thats why I just used "How to update qty into table2 from table1? " This is the scenario of one of my customer Table-1 Subscription Master(News Paper) - Received Subscription CustCode Name Copies date Agent …

Hi I am not familiar in how to create HTML Embeded emeil. Currently I am using below code, It is work fine and send email with plain text. It is not look nice. I need to formated embeded email with logo and below information together to the email. I have …

Hi I am working in weekly Newspaper company. There are 15000 subscriber, subscribed for next 3 to 4 years.Per year 52 weeks and I have to generate issue number based on week(1001......3000) for each subscriber and store into data table. I am using mssql 2012. I have written the Store …

Hi I have an issue in report viewer Printing Paper size is Width:21 cm and Height:13.5 cm. If I try to set in report property using custom size, it will automatically changed to Landscape. But Paper (computer form) in Portrait. Pls Help me how to set paper size Thank you …

Hi I have an issue in store procedure. Error is Msg 4104, Level 16, State 1, Procedure W_usp_SO_Table, Line 38 The multi-part identifier "dbo.SVendorMaster.SVCode" could not be bound. Insert table is working fine. But update command is prompt the error Pls advice me Maideen Here is SP SET ANSI_NULLS ON …

Hi My scenario is I have on text box with date (dd-MM-yyyy). I am using ajax in this text box. I need this date display into another text box with format yyyyMMdd on click the button Because the invoice no Need the yyyyMMdd-00001 when the user select the date. How …

Hi I do not know how to sum the one of the column in #table temp table It is my SP SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[usp_Customer_Due_Until_Now] @Code nvarchar(30) AS BEGIN SET NOCOUNT ON; select code as Code, Name as Name, sum(Nett) SINETT into #tableSI …

Hi I need to disable the export excel in report viewer in asp.ne I have debugged , shows "Object reference not set to an instance of an object" in this line *"Dim ListRenderingExtensions As System.Reflection.MethodInfo = m_previewService.FieldType.GetMethod("ListRenderingExtensions", Flags)"* pls help me maideen Protected Sub DisableFormat(ByRef viewer As ReportViewer, ByVal formatName …

Hi I have an issue in below stored procedure. below Store procedure is working fine. But fixed the Year. Any one know How can do the year dynamically select by user? SELECT * FROM ( SELECT salesEXE,SalesEXEName,name,gross,YearNo FROM vw_Pivot_Month_ALL) TableYearNo pivot (Sum(gross) for [yearno] in ([2008],[2009],[2010],[2011],[2012],[2013],[2014],[2015],[2016],[2017],[2018],[2019],[2020]) )pivotTable pls advice Maideen

Hi I have database in structure like below Newspaper State1 state2 state3 state4 ABC 1000 5684 5687 246 DEF 879 2547 2578 2357 But I need to the structure like below How can i change this Newspaper State copies ABC State1 1000 ABC State2 5684 ABC State3 5687 ABC State4 …

Hi I encounter the above error message while executing import excel data into sql data table. It worked fine in Mssql 2005 x86 and MS Office 2007 x86. But currently we upgraded the system to MSSql 2012 x64 and MS Office 2010 x86. I downloaded the accessdatabaseEngine.exe for MSoffice 2010 …

Hi I have an issue when generate class file, error "Input string was not in a correct format" Pls advice me Thank you Maideen It is my class.vb file Public Function loaddata(inID As Integer, inname As String, inaddress As String, intel As String, infax As String, inemail As String, inregno …

Hi I did the stored procedure in mssql 2012. working fine in server. I have an issue that I need the output of my SP into HTML Report Format in aspx.page with Sub and Grand Total I no need GridView Pls advice Maideen My SP SET ANSI_NULLS ON GO SET …

Hi i have issue in stored procedure converting data type Destination table dbo.Z_tbl_CirculationCopy_TEMP has numeric data type But source table Z_tbl_Import_temp have VarChar Type If I export data from source, I have error message Msg 8114, Level 16, State 5, Procedure Z_usp_IMPORT_EXCEL_UNPIVOT_1, Line 10 Error converting data type varchar to …

Hi I have one issue. I do not know how to solve and also no idea. It is my scenario. I have Product table with details,selling price, purchase price and so on. I want to invoice to clients. Clients can buy lots of item in single invoice. If I select …

Hi. I am new. I don't know how to validate certain data like emai, web site and numeric value. Here is my code which is work fine. Below is my code. Pls Help me add.php <?php include_once '../inc/header.php'; ?> <Script Language="javascript"> function change_action() { var frm_obj=document.getElementById("frm"); frm_obj.action="data.php"; } </Script> <form …

Hi I have another issue in Update. Could not be updated. pls help me if (isset($_POST['update']) && $_POST['update'] != "" ) { $id=$_POST["id"]; $name = $_POST["name"]; $address = $_POST["address"]; $tel = $_POST["tel"]; $fax = $_POST["fax"]; $email = $_POST["email"]; $website = $_POST["website"]; $type = $_POST["type"]; try { $sql="UPDATE bk_customer SET name='$name',address='$address', …

hi I am new in php. I could not insert the data into mysql table. and there is no error prompt Below is my code. Pls help me <?php include_once '../inc/header.php'; if (isset($_POST['submit']) && $_POST['submit'] != "" ) { $name = $_POST["name"]; $address = $_POST["address"]; $tel = $_POST["tel"]; $fax = …

Hi I am new, Pls help me the following issue. When click the update button, ID should be to another page to process the update function. Below is my entire code index.php <?php include_once '../../inc/config.inc.php'; $sql="SELECT * FROM demo order by id"; try { $result = mysqli_query($con,$sql); include 'view.html.php'; } …

Hi I am new in php. Below code works fine. But If I change Select Command Like this: $sql = "SELECT login_id,password FROM user_right WHERE login_id = '$username' and password = '$password'"; It shows error recorde not found. Also I need to show the role of select user. Pls Help …

Hi. problem in where insert data into table. Using vwd 2012 and Mssql 2012. Insert command is working fine in first record. If add another record, it shows "Procedure or Function has too many argument" I have tried may way, I could not solve. Pls help me. Below is my …

Hi I have an issue to update data between two table. I want to update data from one table to another using Store procedure. My code is SELECT NoMonth,ACC_P,StartDate FROM dbo.tbl_Accural_Basic UPDATE WEB_tbl_Accural_Audit SET NoMonth=nomonth,ACC_P=ACC_P, StartDate=Startdate But Nothing happend. It will show the data in select command Pls help me …

Error occured: Procedure .. has too many argument specified I have an issue that when i Update the record there is error "Error occured: Procedure .. has too many argument specified". It is my Store procedure SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER Procedure [dbo].[web_usp_empData_Update] @id bigint, @Code …

Hi, We have MS sever 2012 and MSSql Server 2012. ODBC Connection in Server is fine. But If create the odbc from Client PC (OS Windows 7 profession SP1), it could not connect Error : Server not found or Access Denied. Even in Admin level also, it shows same error. …

hi anybody can tell How can session store in mssql database? How to do SQLServer Session Mode start? Pls help me Maideen