60 Topics
| |
i am trying to do something like this but it gives me error that **cannot convert int to string** , even the field which i am accessing from db is int and i parsed it into int but why ? here is my code: userId = (int)com.Parameters["@ReturnValueUserId"].Value; Response.Write(userId); SqlDataSource1.InsertParameters["@userId"] = … | |
my griedview is half shown on browser's screen and even it disabled horizontal scroller on screen (browser), why ? whenever i fill my gridview with many columns than it is half shown and disables scroller too, why ? | |
see i am using this mode of SQLDATASOURCE configuration ![154](/attachments/small/3/154.jpg "align-left") and now on the basis of this sql statement i want to generate UPDATE, INSERT, DELETE queries, especially UPDATE and i tried my best to do it but can't. this thing is quite possible in the mode given below … | |
i am retrieving textual data from database on my page , asp.net(c#), now i want to save in pdf format and want to store that pdf file on my server(localhost) so how ? | |
during signup by applicant he/she must fill her educational details , total 5 educational levels, 1.ssc 2.hssc 3. BS 4. MS 5. Phd now lets say that an applicant has only BS passed then it mean that he/she would not have fill 4 and 5 option, now i want that … | |
*.cs page code* using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; using System.Data.SqlClient; public partial class advertisementSubmission : System.Web.UI.Page { protected String EmplyrSession; protected int userId; protected void Page_Load(object sender, EventArgs e) { EmplyrSession … | |
***using select query result in insert query*** ***i have this code in .cs Page .cs page*** String query = "select userid from tblUser where email='" + EmplyrSession + "'"; SqlCommand com = new SqlCommand(query, con); try { con.Open(); int noRows= com.ExecuteNonQuery(); Response.Write(noRows); } catch (Exception ex) { Response.Write("Sql Error:" + … | |
in databse tabel i have fieild with type varbinary(max) for storing image, so i achieved it and stored my image but the problem is that when i use this line SqlParameter p8 = new SqlParameter("logo", SqlDbType.VarBinary).Value= productImage; then it gives me an error but when i use this line : … | |
i stored session variable in string variable in .cs page , but now i want to retrieve that string variable on .aspx page and want to put into selectcommand of sqldatasource how ? | |
am using asp.net 3.5(c#) + sql server 200 DB, doing this GIVES me an error , *Error:The multi-part identifier "email@yahoo.com" could not be bound* why ??? using System; using System.Collections; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; … | |
i have imagepath stored in database , now i want to show on asp.net page via datalist , so how to do it , i tried by best and binded textual data from database bt not able to bind or show image on asp.net page via datalist ? i am … | |
i have field (advDetails) in database with datatype TEXT, and i am trying to insert text from asp.net detailsview into database but it isn't working. here is my code. <%@ Page Language="C#" AutoEventWireup="true" CodeFile="advertisementSubmission.aspx.cs" Inherits="advertisementSubmission" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title>Untitled Page</title> … | |
Hi all, Anyone know how to create a data base gives the name of the same parameterized? Example in a store procedure, named 'x', which has a parameter, this will do since the create dabase @variable create procedure creadatabase @db_name varchar (10) as create database @db_name go But this variable … | |
Hi All, I have intermediate knowledge in VB.Net coding. I have searched the web to find help with my issue but to no avail. I mean I can't find one that is helpful though there are some in Web based applications. I have an urgent issue where I want to … | |
hi, i have records in table like this: id v1 v2 v3 1 587 21 759 2 230 4 495 now i want ouput like below: id v1 v2 1 587 21 2 587 759 3 230 4 4 230 495 i am stuck here don't know what will be … | |
I have been searching for the answer for 2 months, but still no success. Below the setup and connection string and all checked already. Firstly my errorlog file error = 18456 Severity 14 State 11 (Login failed for user OLDPC/GUEST. Token based server access validation failed with an infrastructure error. … | |
hi friends. Im currently working in integrating GR Fingerprint SDK with vb.net application. I am using MSSQL 2008 as my database and vb.net as the front end. I have completed almost 90% of the application and im stuck in integrating this SDK with my application. It has an error such … | |
Hello, I have one more question. I am connectinag to SQL Server 2008, not express, and I keep getting the "login failed for user "..."" The connection string I am using is: [CODE] Dim connStrg As String = "Data Source=" _ & ServerAdressTextBox.Text & _ ";Initial Catalog=" & _ DatabaseNameTextBox.Text … | |
I'm new to stored procedures and, really anything about sql beyond the basic SELECT/INSERT/etc... so this is probably just something I don't understand but my problem is that my stored procedure seems to only return the last row of the result set (i.e. if it should return 10 items it … | |
I have a table named "Table1" Its schema with data is like this [CODE=text] Id col2 col3 col4 col5 isUnique dbUnique 1 red 3M 1995 UK 1 null 2 red 3M 1995 UK 0 null 2 red 3M 1995 UK 0 null 3 red 3M 1995 UK 0 null 4 … | |
I am using SQL2008. I want to generate log file of each and every transaction carried out on my table. How can i do this? | |
I have a list of values extracted from a datareader in a list. Is it possible for me to run a query to extract another set of values using a datareader and then use the individual values in the list and the values in the datareader to perform some calculation, … | |
hi.... in which version of sql server i can get the below two option... 1) performance tools 2)database tuning advisor.. please send me the download site... | |
hi...... to all i have one problem in executing the ssrs reports.. i've developed one project for that project there are some SSRS reports which are deployed in path ( "http://localhost/reports/") it is working fine... when i run through the project and press F5 ( i.e execute) the reports are … | |
hi.... i've developed on ssrs report which displays the number in words i.e in million and billion.. i want it in crores ,lakhs,thousands,hundreds,rupees and paise.. can any one modifiy the code below.. which is in reports properties->code tab.. the below is my code which is of million and billion dollars … | |
hi.... The code is about place the comma's (,) i.e separator between numbers in this format (12,21,21,123) it works good.. but when there's a decimal point such as 12345.58 it will show as 12,346.. it will round up the values.. ( which i dont want that .. i want as … | |
hi... to all.. i've developed one ssrs report in "sql server 2008 express with advance services"... The virtual folder is not there in IIS .. ok it works fine .. i.e [url]http://mysystemname:8080/reportserver_sqlexpress[/url] it works good... but the same thing i want to execute in another system .. with my system … | |
hi.... to all.. i'm using sql server 2008 express with advance edition with BIDS... i've developed one report in that employee salary.. i want to print the salary in the format (12,34,56,78,91,01,11,233.89) and i want to print in words such as (" ninty nine crores fifty one lakhs fourty nine … | |
| hi, Am having a problem Inserting into SQL 2008 database using stored procedure from a php webpage. My Stored Procedure is: [code=text] Create PROCEDURE [dbo].[udp_AddContact_Insert] @Contact_ID int, @Client_ID int, @STD varchar(10), @Tel varchar(20), @Mobile varchar(20), @EmailAddress varchar(100), @FirstName varchar(20), @LastName varchar(20), @Title_ID int, @Position_ID int, @User_ID int, @SourceURL varchar(1000), @PositionText … |
Hi Guys, I am currently creating an application to track timekeeping (a clock in/out system) and I am trying to work out the best way to do this. I have a Main Form which contains buttons to ; - Log in - Out for Break - In from Break - … |
The End.