cyberdaemon

you can use the property of the combobox... you can use refresh or update

you can use double \\ for the path or use verbatim @ before the string text..

you can try this. [CODE] dim tableadapter as new dataTable dim position as integer = 0 'for the first record position = 0 textbox1.text = tableadapter.rows(position)("yourfield").tostring() ' for next record if tableadapter.rows.count > 0 then position = posiiton +1 textbox1.text = tableadapter.rows(position)("yourfield").tostring() ' for previous record if tableadapter.rows.count > 0 …

what version of visual studio are u using?

Good day, I am having trouble with the excel file that i was uploaded.. after i uploaded the excel file i want to validate each header and each datatype of it. just to make sure that my dbase has integrity.let say i have 10 columns. Is there a way on …

use telerik..

Good day coders.. I just want to query how could i solve my problem regarding gridview, I want to compare the value of the current row to the previous row of the column, I dont know were should i start. (ex. id, matnum,soldtoplan 1, 101, 10101 2, 102, 10102 3, …

Good day, I am having troulbe with my computation here. i want to compute for the Custom_Haulage_In_Transit but when i exec my sp the value of the Custom_Haulage_In_Transit is 0. can anyone help me with this please.. here is my code SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant …

i think u need to upgrade your OS into SP3,also upgrade your .net framework into 3 or so..

it's better to put what you have done so far, on that we will guide to the rest of the project..

Good day, I am having trouble with my condition, i dont know where should i put where in my query here is my code.. SELECT distinct MATERIAL ,Description ,Material_Type -- ,Requested_Delivery_Date ,ATP_check ,Delivering_Plant ,Order_Quantity ,Held_by_Finance ,Rejected_OOS ,Rejected_Others ,ISNULL(Open_Order_Quantity,0) AS Open_Order_Quantity ,ISNULL(Order_Quantity_NKA,0)as Order_Quantity_NKA ,ISNULL(Order_Quantity_RKA,0) AS Order_Quantity_RKA ,ISNULL(Order_Quantity_Others,0) AS Order_Quantity_Others ,ISNULL(Stock,0) AS …

try to use join, after joining the field try to concetenate the field that you want the user can see on the GUI..

you can use select @scope_identity in sql...

try to use if exists in sql.. on that way, that's the best to handle duplicate entry in the dbase..

cmd.Parameters.AddWithValue("vDate", dateTimePicker1.Text); double check this line.. i know u knew what is wrong.. another is cmd.executeNonquery(); is missing..

please clarify your question.. put your codes

try u use select top 2 from your table then use joining.. or else, ellaborate what you want just to be clear..

Good day, I am facing a trouble with my project. i want to load the database in my session but i dont have idea on how to do it. session["getName"] = _BLL.GetName(_myEntities); Response.Redirect("otherpage.aspx",false); on my master page. myLabel.Text = session["getName"].ToString(); that's my code. i want to get the record on …

Good day, I am having trouble with my dbase. i have 2 tables first is the maintenance table while the other is transactional table. on my maintenance table i have field(id, plan, material,type,percentage) while on the transaction table (id,material,description) here is my problem. on the maintenance table let say id …

Good day, I am having a probem with my sql. I want to create a formula for my pivot field.. here is my code... SELECT * FROM ( SELECT REPORT.MATERIAL ,REPORT.Description ,REPORT.Material_Type ,REPORT.ATP_check ,REPORT.Delivering_Plant ,REPORT.Order_Quantity ,REPORT.Held_by_Finance ,REPORT.Rejected_OOS ,REPORT.Rejected_Others ,REPORT.Open_Order_Quantity ,REPORT.Order_Quantity_NKA ,REPORT.Order_Quantity_RKA ,REPORT.Order_Quantity_Others ,REPORT.Stock ,REPORT.DSD_Delivery ,REPORT.OUtBound_Haulage ,REPORT.Total_OutBound_items ,REPORT.InBound_Haulage ,REPORT.Haulage_In_Transit ,REPORT.Process_Order ,REPORT.Total_Inbound_Items …

@akkbkht your project is not small as it is.. it huge project. we've been creating that on my last company.. but since your just starting on that project you can start by the table creation.of course u must have patient table..patient table must generated patient number.. maybe arounf 10 char.. …

Good day, I am having trouble with the computation in SQL. i want to subtract the intStock and the intTotal_OutBound_items to just to get the items available. here is my SP.. INSERT INTO CO09_Report ( intMaterial ,txtDescription ,txtMaterial_Type ,txtATP_check ,intDelivering_Plant ,intOrder_Quantity ,isHeld_by_Finance ,isRejected_OOS ,isRejected_Others ,intOpen_Order_Quantity ,intOrder_Quantity_NKA ,intOrder_Quantity_RKA ,intOrder_Quantity_Others ,intStock ,intDSD_Delivery …

try to use SSIS..

have u try to use xml.? here is example of it.. and place save it in the sql table @xmlInTransit xml INSERT INTO tblInTransit ( ReceivingPlant ,SupplyingPlan ,STONumber ,ItemNo ,Material ,MaterialDescription ,Quantity ,Unit ) SELECT NODE.value('@ReceivingPlant','[varchar](4)') ,NODE.value('@SupplyingPlan','[varchar](50)') ,NODE.value('@STONumber','[bigint]') ,NODE.value('@ItemNo','[int]') ,NODE.value('@Material','[bigint]') ,NODE.value('@MaterialDescription','[nvarchar](50)') ,NODE.value('@Quantity','[int]') ,NODE.value('@Unit','[int]') FROM @xmlInTransit.nodes('dsExcelInTransitRecords/dtExcelInTransitRecords') TEMPXML(NODE) once it compiled you …

you can use join in your queries. SELECT * FROM Investments I inner join Funds F on I.FundID = F.FundID inner join Currencies R on F.BCurrencyID = R.CurrencyID inner join Funds_Shareclasses C on C.SCurrencyID = R.CurrencyID inner join Companies P on I.CompanyID = P.CompanyID WHERE I.CompanyID LIKE varCompanyID AND I.FundID …

you can use the sql jobs all yo uhave to do is to create a job that will back up your dbase. u can choose full back up if you want to back up the whole db. or the other option..also you can set the time of your back up..

Good day, I want to get the latest value of the newly inserted record in my label.. The value that i want to get is not the primary key. Here is my code . //for saving _patientInformation.firstName = txtFname.Text; PatientInformationBL _patientBL = new PatientInformationBL(); if (_patientBL.addPatientInfo(_patientInformation) == true) { lblMsg.Visible …

Good day, I am having trouble on how should i clear the value of my controls in the modalpopupextender. Assume the i have 1 textbox in it. oce i clicked the button with any name. all i want is to clear the value of the control.. thanks

try to declare the returnString at the top of your code.. after the method.. and specify the datatype..

try to use AJAX.. and use modalpopupExtender. that's the easiest way..

where did the data coming from..? i mean what are the data that will autocomplete?is it in the dbase?array?or what?

Good day, I just want to ask how could i start to create a simple database using SQL server 2008. I have all the employee images that was on the folder, if i create a table for let say employee table. All i want is to create a link or …

Good day, I am stuck at his moment figuring how could i solve this porblem.. I created a method that will retreive a value from the dbase and place it in the dropdownlist.. so here is my code protected void ddlSalesOrg_SelectedIndexChanged(object sender, EventArgs e) { _lkpPlantEntities.plant = ddlPlant.SelectedValue; _lkpCustomerEntities.txtSalesOrg = …

Good day, I am having problem with displaying my image on the my form.. the image is already uploaded and saved on the folder. so all i want is to retreive it and place it on the other form. This is web application here is my code private void GetImages() …

Good day, I have a module that upload a record using excel file, and that excel file will be save into the table.. actually i already created that but one ofmy requirement is to clear first the record in excel before it will be uploaded.. how could i clear the …

Good day,, I am having problem with the autocompleteextender in my application. i already created a webservice.. here is my code <asp:TextBox ID="txtSKU" runat="server"></asp:TextBox> <cc1:AutoCompleteExtender ID="aceSKU" runat="server" Enabled="True" ServicePath="http://localhost:3099/WebService1.asmx" ServiceMethod="GetMaterialName" TargetControlID="txtSKU" MinimumPrefixLength="2" CompletionInterval="100" EnableCaching="true" ShowOnlyCurrentWordInCompletionListItem="true" > </cc1:AutoCompleteExtender> and here is my whole webservice code using System; using System.Collections; using System.ComponentModel; …

Good day, I want to use N-TIER for my application.I have DAL and BAL already, since i have that 2 project already. am missing 1 project which is the UI.so i created my UI project. Since am excited to test my simple n-tier i created a simple GUI using gridview …

Good day, I was stock in the middle of developing a simple application. All i want is to bind the data into gridview, everything is fine when i binding into a single table. i need to bind my gridview using two table. my stored procedure is wroking correctly. here is …

Good day, I am havinf trouble with the pageindexchanging in my gridview here is my code; my PAgeIndexChanging code protected void gvPatientInformation_PageIndexChanging(object sender, GridViewPageEventArgs e) { GetPatientInfor(_patientInformation); gvPatientInformation.PageIndex = e.NewPageIndex; } my Method Code private void GetPatientInfor(PatientInformation _patientInformation) { gvPatientInformation.DataSource = PatientInformationBL.listPatientIformation(_patientInformation); gvPatientInformation.DataBind(); } My BLL code public static DataTable …

Good day, I'am having a problem regading the computation in sql. I been using C# and am creating a web application. All i want is to multipy the value of the record from one table and multipled it with the other table. s oi caome up with this idea. @MARKUP …

Good day, I created a simple search in sql. inside the textchange event. everythis seem to be ok for text box. i want to have another search with the other text but this time i want to use the first search and concat it with the next condition.. here is …

good day, i have a table named information i created a stored procedure that will search for thier name, "firstname","middlename" and "lastname" that 3 field is concatenated and named it fullname My problem is that i want to count the result of my query that count the total number of …

i have here my search code. i want to search for firstname, and gender, but what if firstname is empty and gender is the one were going to search. but the gender is not filtering they just filter the name. any suggestions.. SELECT --ACCOUNT_CODE --HOSPITAL_CODE MRN ,CONVERT(DATE,BIRTHDATE)BIRTHDATE ,FIRSTNAME ,MIDDLENAME ,LASTNAME …

Good day, I want to search something from my database. my queries are working DataRow dr = PatientInformationBL.GetPatientSearch(new PatientInformation { firstName = txtFname.Text }); actually the GetPatientSearch is a method that is connected to my DAL. the codes returns no error but it displays in datarow.the result should be put …

Good day, I just want to asked regarding SQL. let say i have a table for discount.using SQL query. here my table name A Item Price A 100.00 B 200.00 C 300.00 Assume that there's 20% discount if the price is greater than 200.00 Discount should apply 1. How could …

Good day, Is it possible to create a simple entity framework system withou using DAL? or maybe context? direct connection? let say, i want to extract all my record in gridview. //assume that this is my formload protected form_load() { if(!isPOstBack) { getAllRecord(); //mymethod to call the data taht will …

Good day.. i was stuck a moment realizing what went wrong to my project. I'm currently developing a enrollment system. I have 3 tables in my DB namely course_code,curriculum and pre_requisite tables. on the course_code table i have fields course_code(PK),course_desc. on the curriculum table i have but in this table …

Good day, I am having problem with the saving. all i want is to save multiple records at once. i used user define table in sql server 2008. my stored proc seems be right coz i already tested it.. my problem is that once i selected a record from the …

how can i save multiple record in single click using user define data type in SQL i am having problem in selecting the value in gridview using checkbox here my code View // View LAyer protected void imgbtnSave_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow = …

how can i save multiple record in single click using user define data type in SQL i am having problem in selecting the value in gridview using checkbox here my code View // View LAyer protected void imgbtnSave_Click(object sender, EventArgs e) { DataTable dtTable = new DataTable(); DataRow dtRow = …