- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 5
- Posts with Upvotes
- 4
- Upvoting Members
- 3
- Downvotes Received
- 0
- Posts with Downvotes
- 0
- Downvoting Members
- 0
38 Posted Topics
you can try Ajax extender for modalPopUp is asp.net... try this link.....[URL="http://www.asp.net/ajax/ajaxcontroltoolkit/samples/modalpopup/modalpopup.aspx"]http://www.asp.net/ajax/ajaxcontroltoolkit/samples/modalpopup/modalpopup.aspx[/URL]
what is the version of Dot Net Framework you are working with ????? framework 2.0 doesn't support .xlsx format
in your sub reports did you put the field in other than [B]details [/B]section..... i feel it should have in Details section..
generally in this case no code to be written in asp.net as you can use expression validator to check for your inputs at client side. try dis: [CODE]^[0-9]+$[/CODE] Hope this helps
Use dynamic connection string rather than hard code. Get your connection string from settings file all the time. then you can simply create your setup file and install into client machine. After installation just change the setting file as per the client info (You can find it in installation folder …
try dis [CODE]cmd.Parameters.AddWithValue("@FormedClass","'"+ TextBox6.Text.Trim()+"'")[/CODE].. for nvarchar data type it always assumes value without qoutaion as integer
:yawn:To keep it simple open your second form i.e. Form2 as modal window and while closing the form you can easily access its value to Form1... While clicking on apply retreive your required data into a public variable Try This: [CODE] //Fomm2 Code: //on Click event of apply button public …
[QUOTE=;][/QUOTE] You can add one application configuration file and put your connection strings out there.....Now access connection details from itself rather hard coding it in each coding file.....You can create setup of your application now and after installing it to a client machine you will find this settings file in …
Have you registered your sql database with asp.net????? else you first run [CODE]regsql.exe [/CODE] from visual studio command prompt.
I haven't found any code block above, where you are filling your combobox. you are querying from database based on inputs of the combo.. But in your post you are saying no value is coming in combo box...??? its really confusing... :-O
use a function to manipulate your actual date and to return desired result, and then retreive your query result through that function. That should work... You can try this: [CODE] CREATE FUNCTION [dbo].[CorrectDate] (@bDate varchar(12)) RETURNS VARCHAR(12) AS BEGIN DECLARE @dt VARCHAR(12), @Yr VARCHAR(4), @actualdt VARCHAR(12) SET @dt=@bDate SET @yr=SUBSTRING(@dt,7,4) …
You must use MySql instead of Sql . ie [CODE]MySqlConnection instead of SqlConnection [/CODE] apart from this everything is similar between sql server and mysql
[CODE]cblOptions.Items.clear()[/CODE] add this code before your while loop and remove the checking
use validating or validated event for your purpose & put this within the block. [code] int a = int.Parse(textBox3.Text); int c = a*2; textBox3.Text = c.ToString(); [/code] ---------- Use sqlcommand here rather than dataadapter and dataset. [code] if(con.State= ConnectionState.Open) con.Close(); con.Open(); SqlCommand cmd=new SqlCommand("select Lot from Future where Script_Name='"+ comboBox4.Text …
[CODE] using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.Sql; using System.Data.SqlClient; public partial class webTest : System.Web.UI.Page { SqlConnection con = new SqlConnection("Server=(local); Database=test; user id=sa; password=itdept"); SqlCommand cmd; SqlDataAdapter da; DataSet ds = new DataSet(); …
You can open your table in Desing mode,add the column of registration date with datatype of datetime then go to column properties and in "default value or binding" properties add "getDate()" without qout as value. Now save the table, From now on you do not need to do anything, whenever …
convert your database feild with bigint instead of int or make it as numeric
[CODE] System.Drawing.Printing.PaperSize pr = new System.Drawing.Printing.PaperSize("B4 (JIS)", 10, 6); [/CODE] put this above stated code after providing the report source... or if u want to do it from design mode then right click on the crystal report(.rpt file) select design then printer option. from there you can provide your required …
[CODE] "INSERT INTO finaldata (Hall, Bedspace, AmountPaid) SELECT * FROM AllcDataBoys WHERE Bedspace ='" + (Bespx.CompareTo(RET) == 0) + "' AND RegNumber ='" + txtRegNumber.Text.Trim().ToString()+"'"; [/CODE] Hope this helps :)
[CODE] UpperCase(ToWords ({#SummaryFeild},0)) [/CODE] You can try this code.... It worked for me in lower levels (for Thousands) take a formula feild and in formula put this code..... Note:'ToWords' is provided by crystal report . If it doesn't work try it without the '#' symbol Hope this helps.....:icon_idea:
While storing value into your string, put a blank space between each character and then split the string with the help of that space... you can use this piece of code. [CODE] string val = "1 + 2 - 3 + 4"; string[] strSplitArr = val.Split(' '); [/CODE] you will …
[CODE] OleDbConnection con; System.Data.DataTable dt = null; string conn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" +"Excelfile path with ExcelFileName + "; Extended Properties=Excel 8.0;"; con = new OleDbConnection(conn); try { con.Open(); //get the sheet name in to a table dt = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null); String[] excelsheets = new String[dt.Rows.Count]; int i = 0; …
[CODE] <%@ OutputCache Duration="1" VaryByParam="none" %> [/CODE] You can put this code just under [CODE] <%@ Page Language="C#">[/CODE].. Hope this helps..:)
I have a aspx page where am showing a pdf document using iframe. and beside it am dynamically creating linnks of last 5 uploaded pdf files. Now I want to change the pdf showing through iframe to change on respective hyperlink click. I have shown the pdf and the links …
ans2007kumar suggested nice... You just create a folder and put the pics in there and store the relative pic name and path in your database. It's much faster and easier way
simply retreive the contactname from database with that query. [CODE] SqlCommand com = new SqlCommand(cmdString, con); string contact=Convert.ToString(com.ExecuteScalar()); [/CODE]
How can I use 'like' keyword with wildcard characters(*) in RecordSelectionFormula of crystal report? [CODE] rptdoc = new ReportDocument(); rptdoc.RecordSelectionFormula = " {View1.RefNo}= '" + textbox1.Text + "'"; [/CODE] I need to use 'like' instead of '=' .....
Best way to do it Store user details in session when login and with logout clear session data, On every page load event check user credential then only proceed else redirect it to login page.....:icon_idea:
try putting this.... string sourceFile = @"C:\\new1\\*.txt"; string destinationFile = @"C:\\new2\\*.txt";
to solve your connectionstring problem, you can add one Config file to your project and write the connection string within it. [CODE] <?xml version="1.0" encoding="utf-8" ?> <configuration> <appSettings> <add key ="SqlCon" value="data source=SERVERNAME;initial catalog=DATABASENAME; user Id=USERID; password=PWD;persist security info=false;"/> </appSettings> </configuration> [/CODE] Add this code within your config file, then …
Your can use this code: private void TextBox1_KeyPress(object sender, KeyPressEventArgs e) { String key = Convert.ToString(e.KeyChar); if (key == "r")// r notifies return key { btnSearch_Click(null, null); } }
You can check this link.....[URL="http://www.daniweb.com/forums/thread169182.html"]http://www.daniweb.com/forums/thread169182.html[/URL]..Hope this will help
There is no need of installing Visual studio on client place, But you do need to install sql server locally or on server. dot net framework and sql server will do the job. If exceptions occur due to assembly files add copy required dll files into your application's BIN folder. …
While using access database always first make sure you are not using any keywords as your column_name, Other wise it will give you error while updating without giving any proper exception message. You must post the original exception message to get the better idea of your problem.
if u r using sqlserver, it should be easy. Before sending it to database traverse the array and make a single string with array values in a "," or ":" then save the string as varchar into database. When u need to fetch the data u just have to break …
[CODE] using System; using System.Data; using System.Configuration; using System.Collections; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.OleDb; using System.Data.SqlClient; public partial class Transaction_Excel : System.Web.UI.Page { SqlConnection connect = new SqlConnection(ConfigurationManager.AppSettings["SqlCon"].ToString()); protected void Page_Load(object sender, EventArgs e) { } protected void btnUpload_Click(object sender, EventArgs …
The best option is to configure your webconfig file. set customErrors mode to "ON" and defaultRedirect="customeErrorPagelink"
string gridCellValue= GridName.Rows[1].Cells[1].Value.ToString();
The End.
mono_jit23